Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Greetings, I found out the formula. Here it is: =OFFSET($A$1,MATCH((IF(B15<1,1,B15)),A2:A11,0),MAT CH((IF(B16<1,1,B16)),B1:K1,0)). I would like to thank my Brother for this. He was reading this and came up with it. Now that I got my hard question out of the way. How do I hide this formula in my spreadsheet? Thanks, Union -- Union70 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random Number generator | Excel Worksheet Functions | |||
Random letter and number generator | Excel Worksheet Functions | |||
random number generation | Excel Worksheet Functions | |||
random number without repeating? | Excel Worksheet Functions | |||
Random Number Questions | Excel Worksheet Functions |