Posted to microsoft.public.excel.worksheet.functions

St@cy

external usenet poster

Posts: 24

Please help w/ INDIRECT

I get "No Show" everytime for the following:

=IF(ISERROR(INDIRECT(ADDRESS(26,MIN(COLUMN(X33:IV3 3)*(X33:$IV33<"")))))=TRUE,"No Show",INDIRECT(ADDRESS(26,MIN(COLUMN(X33:IV33)*(X3 3:$IV33<"")))))

I have an INDIRECT function that works for MAX, but I now want to use MIN.
I need a way to return "No Show" if all columns are blank in columns X:IV.
Please help me fix this function.

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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
INDIRECT.EXT	Danny Lewis	Excel Worksheet Functions	0	July 14th 06 11:00 AM
INDIRECT.EXT	Mike McLellan	Excel Worksheet Functions	2	May 4th 06 02:25 PM
indirect using name	tocguy	Excel Worksheet Functions	2	February 24th 06 06:57 AM
INDIRECT Help	Sandy	Excel Worksheet Functions	5	March 10th 05 01:11 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us