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