Search results

I have to generate some additional calculation out of pivot table grand total, also I have report filter and with that reference row for each filter is keep changing, how write a formula so that my additional calculation always refer the grand total row based on the report filter values. Please...

How to write a formula if range of cells are blank (I mean empty, no values)then it should display "Y" and if not display "N"

I have two columns of data in an Excel spreadsheet. I have to see that every value in Column A has a match in Column B. I understand that two columns can be compared and highlighted in Conditional Formatting using the Match function. The problem is that the the Match function in Conditional...

I'd like to restrict excel values to X and Y only, I know Data validation will do this but , if I enter any other values that will indicate error and when I copy paste any value it won’t indicates error.I want to know hot to restrict copy/paste also for the validated cells.

I need a formula to do sum of tasks for a particular client if the status is closed, client name is listed from the drop down menu. If i select a client A (just for example) from drop down list then the formula should do the sum of closed tasks in a separate cell, if I change to client B than...

I'd like to create a excel report to measure On-time delivery (OTD) and quality of documents of a engineering group for all submissions/passes. For an example, If I submit 10 documents today that were due two days back, OTD should be measured for this first submission/pass. And I receive the...

Hey guys, Pls help me finding the solutions for below. Name Number A 10 B #DIV/0! C 12 D #DIV/0! E 20 F 13 G 18 I've to find out the average for names B,D,F,G using excel formula. Thanks