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

I want to find data that is greater than 1000 (column a) AND greater than 1 in column b. And then remove this data from the original full data set.

Solved by C. B. in 17 mins

I need a conditional formula to highlight cells based off birth dates that are in a column which are under age 17

Solved by M. S. in 40 mins

I want to count how many rows have not had any action taken yet but are not yet Overdue. So my row G from cell G3 to G102 need to be blank and cell F3 to F102 need to be blank. I don't want it to count any rows that are blank (which naturally have the G and F columns blank.
I want to count how many cells have F and G columns blank but still have text in column B which means that there is a task in that row. I've tried a few different formulas but they won't work.

Solved by I. H. in 60 mins

I have an excel file but its a bit sensitive.Now, i want a formula that checks for the customer deliveries and balances to be delivered.Once the column is delivered of course the balance to be delivered should be zero,then it cuts the whole column and removes it from that worksheet and transfers it to the fully delivered worksheet.

Solved by V. H. in 17 mins

i need a formula to put the value in column f into column c, when/if column c matches column b.

Solved by F. J. in 20 mins

HOW CAN I MAKE A TALE FOR ONLY 6 COLUMN?

Solved by Z. A. in 40 mins

I have a spreadsheet that contains a list of names/IDs and I want to generate a formula that inserts into a cell the number of times a name or ID appears on that list. Either insert a column into that spreadsheet or transfer that info into a column on a different spreadsheet. Either way would be fine.

Solved by O. L. in 18 mins

Help with making a combo chart (scatter and column) with multiple series

Solved by Z. Y. in 19 mins

I have a spreadsheet with information on thousands of contacts. Lots of information is mismatched such as phone number in the address column etc.. What is the best way to go about fixing this?

Solved by B. U. in 60 mins