Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

Im trying to get the following to work. 2 sheets. Sheet 1 Box A1 has a name. Sheet 1 Box A2 has a date. If the date in Box A2 is in the future, the name from A1 appears on Sheet 2, box A1 If the date in Box A2 is in the past, the name from A1 does not appear I've just tried, but the helped had all data on one sheet
Solved by M. F. in 20 mins
I would like to create the following 2 formulas within a workbook: Formula 1: Display this month's pay dates (starting from 3/24/2018 and every other Friday thereafter) in cells E4, F4 (and if applicable, cell G4). Formula 2: If any day of the month listed in cells E6 - E 16 falls after the date listed in E4, highlight red the row that lists the date. (I will duplicate this for F4 to affect cells E18-E42). I am not sure how to proceed.
Solved by E. H. in 40 mins
hello I am trying to sum the values in a multi column and multi roq array if the column is equal to a certain value and the row is equal to a certain value
Solved by I. Q. in 40 mins
I need a formula to say the following: if > then 110 then *1.5 if less < 110 then 110
Solved by G. Q. in 20 mins
hello, i am a web developer with woocomerce. i am finishing off a large (ish) store and are looking to give him a launch present. I have an excell spreadsheet of the product data, 600 row, 60 columns. I want each cell to have a colour depending on the number held, use as an hex value, i dont mind really. If its text then a one colour, if an empty cell another. I am kind of looking like the DNA of the shop.
Solved by X. D. in 11 mins
Hi I want to format cells if they are lesser/lower than a specified date. It would be a great help if I get a solution as soon as possible
Solved by K. B. in 23 mins
I have a spreadsheet with a lot of columns and want a cell in each row that will have a comma-separated list of the columns that have data. Essentially, I think I need to create multiple "IF" functions within a cell that will output comma separated text based on whether a column is blank or not.
Solved by K. L. in 27 mins
I need a formula where s36 = 1 if a10=s7 and c10=any value?
Solved by G. J. in 13 mins
I need a formula that sums two separate column and two separate cells and only shows an answer if the resulting number is between 0 and 365 ie L2-G2 but only show the answer if it is between 0 and 365. Thanks
Solved by V. E. in 40 mins
If cell b2 = 56 c3 needs to return A* If cell b2 =50 c3 needs to return A and so on. How can I combine this into one formula
Solved by I. Y. in 22 mins
1 2 110 111 112 128 129

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc