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

    drop down on text and numeric based

    Hello Narayanak thanks again for your time. I changed the formula but when i select complete * complete it gives me -1 and all my other selections are out of order too. for eg. i have to get low =1 med = 2 high = 3 so the multiples should be 2,4,9 but i am getting 2,5,11 etc. i have...
  2. X

    conditional formatting

    that did it.i was struggling with getting the syntax right. thanks once again. you are a saviour.
  3. X

    conditional formatting

    Hello Hui, I will try to give you the cell addresses. Target date - G16 23-May-2012 Expected date - G18 31-july-2012 CF used on expected date. I want the expected date to turn green if it is before the target date - CF formula =$G$18<$G$16 turn green. amber past the target date...
  4. X

    conditional formatting

    This is a very simple CF but i cannot get the logic. I have Eg Target date - 2011/3/21 Expected Date - 2011/4/31 cF rules i have applied if Expected Date < Target Date then fill green in the expected date if Expected Date > Target Date + 30 than fill red. that is if the...
  5. X

    lookup based on previous and current month

    Thanks a million. that worked like a charm. i would never have been able to figure that out. so if i want 2-3 months before i have to minus from the array. thanks again.
  6. X

    lookup based on previous and current month

    I have a vlookup which changes values in the table based on the month. I have the month in the list box and the user selects it and the results change. I have 2 lists Current ap and previous ap. When the user select the current AP say May than the values change. i am having problems trying...
  7. X

    drop down on text and numeric based

    I require some more direction to add on to Istiyak solution . I have to add a 4th element called complete. L=1 M=2 H=3 and complete = 0 so that when i do complete x complete i will get 0 and there will be no score. how is this achieved. i tried to modify the formula but i am getting Complete...
  8. X

    drop down on text and numeric based

    Thanks Istiyak, i changed the order of the match and the list order and got the result i needed. but when i list low,med, high and match low med high it assumed that low = 1 med =2 and high =3 and does the muliplication by the postion of the list. is this correct. can i do it for more than...
  9. X

    drop down on text and numeric based

    Thanks for your prompt reply. i downloaded your worksheet and it is in line with what i need. can you explain the logic. for me the high = 3 Med = 2 Low = 1 h x h = 9 m x m = 4 L * L = 1 L * h = 3 and so on. also on the countif i have to count the number of high, low and med in col a and b...
  10. X

    drop down on text and numeric based

    Hello All, I have a drop down list box that has say 1,2,3 values On selection A B c 1 3 a1*b1 3 1 a2*b2 2 1 a3*b3 The user has to select 3 option say high – red, med- yellow, low – green. Ideally I have to have a drop down box with the 3...
  11. X

    Alternate auto fill in excel

    is it possible in excel that some cells look like blank but does not return blank. for eg.=IF(B2="",B1,B2) when i use if (b2="",true,false) it returns false telling me that b2 is not blank and yet there is no value in it. so when i do this step and do the paste special only value it does...
  12. X

    vlookup for dynamic columns based on multiple data selections

    A very big thanks to Narayanak for having asked me to revisit my named ranges and Luke for helping me with the forumlas. I got it working . the problem was that my valmilestone was a range of values instead of referring to a single cell. thanks once again for all your inputs. it is such a...
  13. X

    vlookup for dynamic columns based on multiple data selections

    http://speedy.sh/cZKtJ/lookupeg.xlsx https://docs.google.com/spreadsheet/ccc?key=0AgD23ALrIXLYdHQ5YmdfXzZmX19Qc0o3T1FSSDUwOEE i have uploaded my file on both these locations i am not sure which one will open. thanks,
  14. X

    vlookup for dynamic columns based on multiple data selections

    My valmilestone is not based on a single absolute value i have 2 pull downs. month and number each time the user can change the intent is that lets say that there are 50 rules. I have chosen that the user displays the top 10 rules relevant for that month. So it could be he chooses the...
  15. X

    vlookup for dynamic columns based on multiple data selections

    Hello, this is what i have i dont think it is working. =INDEX(datatable,MATCH(valmilestone,a1:a3),MATCH(valmonth,lstmonth,0)) Input screen ‘ Col A B C D No Desc Date Month (month is a pull down box) 1 data1 3/4/2012 jan 2 data 2 5/6/2012 5...
  16. X

    vlookup for dynamic columns based on multiple data selections

    Hello All, I have 2 value that i select using a pull down. The number and the month. At each row if i select say no 1 and month May i should lookup the corresponding value. I have used vlookup to get values from the table for all other columns but not able to solve the value for the month...
  17. X

    Alternate auto fill in excel

    Thanks a ton for your prompt response. I have tried Luke response before to autofill Column A and it was successful. But for some reason it was not detecting blanks in Column B. PSG response of =IF(B2="",B1,B2) in my case column B solves my problem. Thanks a ton for this logic.It will save me a...
  18. X

    Alternate auto fill in excel

    Hello All, Can anyone help me with the formula to automatically autofill blanks in excel but in adjacent alternate rows. Eg Col A col B Name Dicipline Name1 Finance blank line Quality blank line Security Blank line Name 2 Security blank line Quality Blank line The intent...
Back
Top