View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muralikrishnan Muralikrishnan is offline
external usenet poster
 
Posts: 6
Default multi range identify & replace

i have a master ref. in a separate sheet. grade 52 to 59; each grade carries
4 quarters. every quarter carries min & max.

i have employees salary on annual basis. now, i have fill for all the
employees, on employee belongs to which quarter based on their grade.

master data in one sheet & 1000 employees list in another sheet.

pls help me