Get instant expert help with Excel and Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula that will transfer data from one sheet to another sheet in the same workbook if that data has a yes in the cell next to it.
Solved by X. H. in 29 mins
I want something which will read eBay link and write available quantity.
Solved by O. Q. in 19 mins
I'm trying to take a data set and uniquely identify how many occurrences that value has in the set
Solved by B. H. in 22 mins
I am trying to create a training spreadsheet that allows me to enter dates that training is carried out and that is coloured green but then expires after 6 months and automatically turns red.
also have a cell to show the % of boxes that are green
Solved by Z. U. in 21 mins
I want to multiply using Excel for finding the tota;
Solved by A. C. in 24 mins
i want to link the staff data from one sheet into a weekly schedule
Solved by E. H. in 28 mins
Having a problem auto populating row data from an excel file using a drop down list into corresponding rows on another worksheet.
Solved by X. W. in 25 mins
Hey! I have 2 tables. each having 2 and 3 columns respectively.
the T1C1(table 1 column 1) have combined values of T2 C1 and C 2. I need to match these columns and return T2C3 to T1C2. I tried Vlookup but it gives me #NA for few lookup values.
PS: every thing is text
Solved by K. E. in 24 mins
I want help with developing macros for a tool i am designing.
1. I want the title sheet to collect the respective district number from the boxes around the numbers and populate it on background sheet under maintenance_dist from e2:e36.
2. The next sheet to pop up should be area screen. If urban is clicked in back ground d2:d36 1 should be populated, If rural is clicked in back ground 0 should be populated in d2:d36.
3. next sheet to pop up is budget category. "<$2mil" or ">$2mil" should be printed accordingly in background sheet from g2:g36.
4. next sheet to pop up is season. the respective names should be populated on R2 in background sheet.
5. next sheet to pop up is Project work type. the user can click on any of the red entries and the respective numbers should be populated from c2:c36. in background sheet.
After the fifth step, I want the Production Rate Estimates sheet to show up.
That's all the help I need code.
Solved by G. U. in 29 mins
The formula i currently have isnt working for all case of an item code i need to edit the forumla to work with all instances
Solved by F. J. in 30 mins