Posted to microsoft.public.excel.worksheet.functions

John

external usenet poster

Posts: 2,069

Match second occurance of value

I am trying to match the second time a value occurs in a horizontal range.
This formula sometimes works and other times does not.... the value I am
matching is TRUE
=HLOOKUP(TRUE,$B$6:$K$7,2,TRUE)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re-occurance	Shannan	Excel Discussion (Misc queries)	3	October 1st 09 05:52 PM
first and last occurance	Darius	Excel Worksheet Functions	7	April 23rd 09 06:49 PM
Count Occurance	ab3d4u[_5_]	Excel Worksheet Functions	2	September 12th 07 09:27 PM
occurance, pivot	haviv	Excel Discussion (Misc queries)	2	February 26th 07 02:43 PM
frequency for each occurance	bjg	Excel Worksheet Functions	3	November 24th 04 02:13 PM

All times are GMT +1. The time now is 07:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us