Max Date
thanks for your quick post, but actually what i want, in Sal&Pmt list
H7:H9996" i have country name (Japan USA etc.etc) same i have in Sheet1 so i
want B5~ equal same country name max date from Sal&Pmt list, hope i could
explain well, that's why i am using =B5 instid of , B5.
Jacob Skaria" wrote:
If you are trying to get the maximum from f7:f9996, h7:h996 and B5 below is
the formula...
=IF($B5="","",MAX('Sal&Pmt'!F7:F9996,'Sal&Pmt'!H7: H9996,$B5))
If this post helps click Yes
---------------
Jacob Skaria
"Tufail" wrote:
hello all,
i am trying to get max date in "Sheet1" from sheet "Sal&Pmt" but #VALUE!
erroe is coming out, any proper way ?
=IF($B5="","",MAX('Sal&Pmt'!F7:F9996,'Sal&Pmt'!H7: H9996)) << upto here
showing, but when i am trying to match data with =$B5 (Sheet1) then problam
is start.
=IF($B5="","",MAX('Sal&Pmt'!F7:F9996,'Sal&Pmt'!H7: H9996=$B5))
|