Dear Friends/ Excel Experts I need formulae to pick next highest value by checking two input values 1) text and 2)number input cells are A53 (TEXT) and A54(NUMBER) formuale should OUTPUT NEXT highest value to number in A54 TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 AND NUMBER IS IN CORRESPONDING COLUMN FROM ROW 1 TO 34 I have attached the sheet with detailed understanding of problem Please help Example ROW1) BAT BALL CHAIR CYCLE WATCH PEN MAT ROW 2 ) ALL NUMBERS . ALL NUMBERS . ALL NUMBERS ROW 34 ALL NUMBERS A53 = BAT A54 = NUMBER OUTPUT SHOULD BE IN A55 AS A FORMULAE FORMULAE SHOULD READ NEXT HIGHEST NUMBER TO NUMBER IN A54 BELOW "BAT" AND OUTPUT IT IN THE CELL A55 Regards Vijay
-- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
FORMULAE FOR NEXT HIGHEST VALUE.xls
Description: MS-Excel spreadsheet
