Get instant chat 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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

If 2 numbers are the same in Colum B and has the Value "D" in colum E, mark Both with "D" in colum F
Solved by T. J. in 25 mins
Hi :) I am working in google sheets. I have a formula that pulls data from cells from a column in another sheet IF the value in a corresponding column for that same row matches a certain value - and it works great. However I would like to extend the formula so that it returns results not just for one specified value in that corresponding column but for any one of a list of specified values.
Solved by I. J. in 29 mins
How do I make a dashboard essentially where you click tabs that lead to other sheets. That way all the information you see is minimized behind tabs.
Solved by D. W. in 14 mins
i have this formula currently which works but not if I want it for every day - any ideas ?? (NETWORKDAYS.INTL(L1362,M1362,11,BH!A:A)-1)*("17:30"-"8:30")+IF(NETWORKDAYS.INTL(M1362,M1362,11,BH!A:A),MEDIAN(MOD(M1362,1),"8:30","17:30"),"17:30")-MEDIAN(NETWORKDAYS.INTL(L1362,L1362,11,BH!A:A)*MOD(L1362,1),"8:30","17:30")
Solved by A. D. in 14 mins
how can i get value of from sheet2 (H column) thats equal to sheet1 (A column)
Solved by T. S. in 29 mins
Hi There, I'm trying to write an excel formula that is an If:then statement but includes a range...example: If Cell is > Cell1 but < Cell2 refer to Cell3
Solved by X. W. in 22 mins
I am trying to create a formula so if a % is above 50 then enter 5, if it's between 11 and 50, 10 is entered, if the % falls below 10%, 15 is entered. uf it is 0, 20 is entered. This is what i have... =IF(W32>50%,"5",IF(OR(W32<50%,W32>=11%),"10",IF(W32<10%,"15",IF(W32=0,"20",IF(W32="",""))))) The first part works but everthing else enters a 10. If w32 is 9% it enters 10. HELP
Solved by I. U. in 15 mins
I have a large spread sheet I need to filter. I can't filter because there are to many blank rows and random blank cells. Ideally I want a formula to delete every row that doesn't have something in a particular column. If not I need a formula to delete just the blank rows but not all the blank cells. Every time i delete the blank cells it deletes everything and i can't filter to select the blank rows because there are two many empty rows and headings.
Solved by I. F. in 27 mins
I would like to make the data in one cell populate into other fields on different sheets in the same workbook.
Solved by X. C. in 30 mins
I am trying to build a timesheet in excel and am having trouble with the timesheet calculator
Solved by Z. A. in 23 mins