Search results

thnx swapnil ...

hi following are the requirement if d = pending with UIDAI(DQC) & E= ""(blank) column G will reflect pending with customer. if d= other option & E=blank column G will reflect pending wth team. if E= non blank column G will reflect closed my column F function is working , were if criteria is...

hi, Iam looking for formula to do conditional formatting with cumulative frequency. Ex- 10-29 (yellow color) 30- 49 (Orange color) 50 & above (Red color) Excel sheet is attached for your reference( conditional formating required for colum d,e,f,g ,i,j,k,l) Pls guide

thnx luke

hi, need the conditional formatting , where if two selected rows are not have same text or numerical will highlight the 1st column. EX if A<>B, highlight A, RED. in attachment the requirement is, C<>G, highlight C, RED. D<>I, highlight D, Green.

thnx prasad...

hi, need a help on setting if criteria on specific date. While for calculation of TAT days before a specific date I need to set a another column against which their desired deadlines are set so that i can calculate their networkdays by subtracting it EX- if a item was delivered in a location...

including showing error 424

hi can any one help me on this through conditional formatting, new rule if i write=ROW(A1)=selRow =COLUMN(A1)=selCol it converts into =COLUMN(A1)=selCol =ROW(XEV1)=selrow & didn't get any result.... Pls suggest why iam getting error

Hi, Unable to get the desired result. Requirement: in column D, source is column C if c5 >200 , D5=7 c6 <=200 , D6=5 c7 <=200, d7= 5

Hi Deepak, I need the count of row. pls reply. Thnx

Hi hui, I need the count of row. pls reply. Thnx

Hi, Unable to do it, with multiple criteria range. 1) countifs require for sales(column C, against column A, mgr) Required to find out count of sales against mgr, but store location should be required to taken in critera to find the count as 2 mgrs are taking care of same location

thnx luke & p45cal

hi, unable to do that, it will be helpful if u mention the stepwise step.

whether i can apply this with < formula or i have to create new formula

Thnx luke & p45cal for if response, but enable to get CF details, can u share the step from where i need to start.

Hi, Need ur help on conditional formatting & if criteria: I req if E F G H < D colured in Red. D= whole column as my data varies in each row, so need to set formatting against column D, but able to do for D3, where all data format accordingly D3. requirement: E3, F3, G3, H3< D3 E4, F4, G4...

Pls provide the details of consolidation,when i am selecting the data its taking as sheet! if iam writing it as pivot it didn't consolidate the data & return the error , in the xls zone column is added with do code..pls provide the details to segregate that.

& when i am selecting the data its taking as sheet! if iam writing it as pivot it didn't consolidate the data & return the error , in the xls zone column is added with do code..pls provide the details to segregate that. Thnx for quick reply:-)

pls provide the steps for consolidation it.

Pls let me know in case we can add or subtract data from to different pivot of same field. Ex: I require to sum column B With column I & column C with J . & with the results need to create another pivot table.

unable to do it...pls provide an ex. in excel sheet..thanx.

can u tell me, how can i upload a attachment for your reference.

Hi, thanx...but can u provide a sample of advance filter as u decribed in the later part with my inputs whiout changing the date format...I try the way you describe. but unable to get the result. thanx