|
|
#1
02-06-2017, 07:04 AM
|
|||
|
|||
find the first value and the last in row
what i try to do is to find the char. Last edited by shanibore7; 02-07-2017 at 05:46 AM. 
|
|
#2
02-06-2017, 07:46 AM
|
|||
|
|||
|
0.86 =INDEX($K$1:$AV$1,MATCH(TRUE,$K2:$AV2="*",0)) (Array formula)
0.98 =LOOKUP(2;1/($K2:$AV2="*"),$K$1:$AV$1) (Non-array formula) Array formulas must be committed by holding down Ctrl and Shift before pressing Enter.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| find IP in range / find number between numbers | gn28 | Excel | 4 | 06-14-2015 03:46 PM |
 Find where find text contains a double quote
|
norgro | Word VBA | 1 | 01-23-2015 10:58 PM |
| find 2 values i a table to find the right prise | Vibov | Excel | 1 | 01-11-2015 07:25 AM |
|
Find what box in Find and replace limits the length of a search term
|
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
|
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Windows XP 
Office 2016
Linear Mode
