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...

Thanks Kaushik and Deb..its working fine..have a great day!

@Kaushik, Pls check your formula shows N only if A1 has data, if you keep A1 blank and you write some numbers in A2, A3, ...it shows Y..this is wrong i think

Hey, @sgmpatnaik Your formula is not working.

I want formula in different format, formula should look range of cells, if the all range cells are blank then it should display " Y " and if not display " N "

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...

Yes, even with that its not working,

Hello, Its working fine only for small range of cells, i added same code for 4000 rows with 10 columns and if I pick any value from drop down list, excel will shutdown. Please suggest me on this. Thanks

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.

hello, let me try, in addition to the status and formula should look for the closed months also.. for example formula should count all the closed documents in JAN for client A and next formula should count all the on-time closed documents in Jan for client A, so that i can calculate the %...

hey Luke, this is not working, i'm getting "0" answer.can u explain in detail. basically formula should refer to one column for client name, one column for status. If I select particular client in drop down list, formula should count( do the sum) of closed tasks for the client selected in drop...

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...

Hello, Data is stored with documents with date of submission. As you mentioned I need no. of days difference and also the OTD % for submitted documents. Same logic for quality also.

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...

I want get average of only 1,3,5,6. basically for the numbers are not in range.

I didn't get that. can you explain it with example?

Hey, I'm looking for formula that it shouldn't consider error value itself to calculate average.With your formula it shows 0 instead of #DIV/0! but it'll consider 0 for average calculation.Is any other formula to calculate average excluding #DIV/0! and data are not in range. Please suggest. Thanks!

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