i have csv files, in one file is categories for opencart, in another file is products. Problem is, in cate...categories have numeric ID. but in product file categories have also numeric ID, but subcategories is just as text. i need it to import in opencart (i have module) , but i need it convert categories and subcategories in opencart>style>to>import
...format that I want to automatically convert in another format in excel and calculate the total time. The source will always be in the "Employee attendance" format and should be converted to the Proper Format workbook. We should be able to copy new time data in the Employee Attendance format and the excel workbook Proper Format should be automatically
I need an excel expert to create an excel file that allows the follow: - I have 3 lists of words (40 words on each) - I need excel to randomly select 30 words (10 of each block) without repeating them. All in the same space (so I can easily copy and paste).
...tab This must work in Excel 2007 and Deadline is Thursday the 19th The Date column is used to get the records only for a date period I want The Name column list here is automatically generated from finding the distinct Names in the Name column The Actions and Amount row are tallied for that specific Name The Average is a simple average on the tally
So i have a table of data ("Misplaced Histroical" sheet). I need a formula or code written that will take the date of the report and the feed type and look up the following samples and analysis in the table. It needs to find the samples closest to the date of the report then copy the results of the samples and paste them back into the process report
I need the formula written for Microsoft excel that will do the following: I do not know the correct way to express my formaula professionally but i have tried to write it our below. I am willing to discuss with you any questions before you start. At this point there are 2 excel spreadsheets involved. (sheet1 and shee2) i have put this after each
I need help for someone to develop a template in excel with formulas and formatting so that I can input the data and everything will work. Need asap by Friday happy to pay
Hello, We would like someone to write a patent for our company using standard patent template. We will provide all the details, claim, art work, etc... Previous experience required.
Would like to setup a formula for the following excel file. If columns E+F is between 0-9.99, column I should be [(E+F)*4 ]+ (H*175).... (Assuming H is 1. If H is greater than 1, the second half should be (1*175) + ((H-1)*150). Also want to include the following in the same formula... If columns E+F is as below, it should be multiplied as stated below
Hi Team, I need somebody to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [увійдіть, щоб побачити URL]
I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.
I have a excel file and a test Power BI. I need help to create a DAX formula to calculate attrition. The test file has a hire date and a term date. Need to get the start headcount by removing anyone hired during the selected month or quarter or in the future. Remove any terminated employees that were terminated during the month or quarter selected or
I have a spreadsheet, 1st column is dates & time, 2nd and 3rd column are numbers. I want to a) average the data in columns 2 & 3 when the date in column 1 matches a date in a column I've made somewhere else; I also want to find the min and max for the column 2 & 3 data. The data have been gathered every few minutes. I want to graph as avg, min or max per every 24 hour period. ...
I have a spreadsheet that i am trying to use a formula to assign a number to duplicate rows. I need someone to show me the correct formula. Easy money for someone.
Looking for a Freelancer to use provided Excel template and columns H:M to identify winning (Yellow highlighted) and losing (Red Highlight) patterns for every horse (broken down by rows) in the spreadsheet. There should only be 2 patterns/algorithms per horse. Please make sure that your solution is formula based so new data sources can use. Preferably