# 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

Hi there! I'm trying to find the 'Age in Days' for each 'Enterprise Partner' on the 'Find Age' Days tab from the data in the 'Data' tab. I believe you can use a COUNT function, but I'm not sure I'm using it properly. Please provide an example of count function in excel for me to follow
Solved by A. W. in 16 mins
I have two lists of data, lets call them the gold list and the blue list. Both lists have names and emails of people. The blue list is the most up to date, while the gold list has emails that are absent from the blue. I am trying to find a way to pull over the data from the gold list, in order to fill in empty spaces in the blue list, without overriding blue list entries
Solved by G. U. in 19 mins
Vlookup not working for cells L2 and M2, I need to resolve the issue.
Solved by F. L. in 25 mins
I need help on conditional formatting dates. So in short, I need the cells to be red if the date is between the 1st and 14th, then green if the date is between the 15th and 30th (or 31st). The current formula I am using is the following: RED =TODAY()>DATE(2017,8,1) =TODAY()>DATE(2017,9,1) =TODAY()>DATE(2017,10,1) =TODAY()>DATE(2017,11,1) =TODAY()>DATE(2017,12,1) GREEN =TODAY()>DATE(2017,8,15) =TODAY()>DATE(2017,9,15) =TODAY()>DATE(2017,10,15) =TODAY()>DATE(2017,11,15) =TODAY()>DATE(2017,12,15) So, I went in to the "Conditional Formatting" then went to manage rules, add rule. Then I did it in order of month, red to green. For example I would copy and paste the 8/17 red code and then the 08/17 green code, in order up to December 2017. It is now the 20th and I opened the excel sheet to check if the cell would be green because the date range but it is not. I have an attachable image.
Solved by E. F. in 19 mins
I am missing something in the Vlookup function. I need to find all employee id in table 1 that also exist in table 2. Based on that it should read "exist" or "not exist"
Solved by Z. F. in 21 mins
I need help with a Countifs formula. I need help soon please
Solved by A. E. in 21 mins
Hyperlinking a drop down list with a front sheet to another tab.
Solved by V. F. in 13 mins
I need to roll forward a power pivot driven file into our next fiscal year, I can only get so far and can get the current year P&L to work correctly, but the balance sheet is not bringing up the true values, as its not returning the prior year accumulated balance... and it did before!
Solved by O. E. in 19 mins
is there a way to combine a sumif and a countif function together: =SUMIF('Store Data'!BM:BN,"*"&B21&"*",'Store Data'!BL:BL(COUNTIF('Store Data'!BQ:BQ,"Yes"))) Currently the above formula returns the answer #REF
Solved by S. H. in 16 mins
A formula that worked when one of your people helped me online is not working on my native file on desktop
Solved by T. J. in 15 mins