• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    multiple if criteria with 3 results option

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

    conditional formatting for cumulative frequency

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

    conditional formatting for not equal to value in two rows

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

    hi, need a help on setting if criteria on specific date

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

    if criteria( need help)

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

    countif for multiple criteria

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

    Conditional formatting & if criteria

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

    Required sum of two pivot table data

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

    advance filter

    Hi, iam using 2007 & unable to find out the way of advance filter. I need to filter between range (ex-06-July-2012 00:00 to 16-Dec-2012 18:00)& i have rows upto ag & upto 800 column. Pls advise.
  10. R

    is it possible to subtract 2 sumif in single function

    Hi, Iam working in different excel sheet & prepare a summary report on daily basis, i need help on sumif data, where i can subtract 2 sumif(result) @ a time...
Back
Top