EXCEL gurus?

Talk about everything but Kick Off.

Moderator: Moderators

User avatar
Stainy
4000+ Poster!
4000+ Poster!
Posts: 4304
Joined: Wed Jun 13, 2001 12:00 am
Location: Concord,NC, USA
Contact:

EXCEL gurus?

Postby Stainy » Tue Feb 12, 2013 9:52 pm

So I have this
=IF(INDIRECT(N1&"!ah7")=0,"",INDIRECT(N1&"!ah7"))

I have a header sheet. in this sheet I have a drop down selection that picks another sheet, once I`ve choose the sheet the data from that sheet is displayed in the header sheet. That's all well and good.
If the sheet returned has zero`s in it then it prints nothing

I don`t want that, if the value is 0 then print that value.
But some cells won`t have anything in there at all.. and I want it to print nothing if there is no data at all


erm.. hard to explain..
Image
User avatar
durban
Site Admin
Site Admin
Posts: 19757
Joined: Wed Jun 13, 2001 12:00 am
Location: Cheshire, England.
Contact:

Re: EXCEL gurus?

Postby durban » Wed Feb 13, 2013 10:10 am

Sorry mate, had a word with our 'bloke' on site and he is not sure.
No longer the only UK based Liverpool, Nottingham Forest and Crewe supporter in the whole of the KOA!!!
User avatar
Vag
Newbie
Newbie
Posts: 378
Joined: Sun Jun 22, 2003 11:58 pm
Location: Athens
Contact:

Re: EXCEL gurus?

Postby Vag » Wed Feb 13, 2013 7:25 pm

I'm not sure, but try
=IF(INDIRECT(N1&"!ah7")="","",INDIRECT(N1&"!ah7"))
or
=IF(LEN(INDIRECT(N1&"!ah7"))=0,"",INDIRECT(N1&"!ah7"))
Click here and here.
User avatar
Stainy
4000+ Poster!
4000+ Poster!
Posts: 4304
Joined: Wed Jun 13, 2001 12:00 am
Location: Concord,NC, USA
Contact:

EXCEL gurus?

Postby Stainy » Wed Feb 13, 2013 11:22 pm

Vag: yes the first one works..got the answer from an Excel guy at work :)


Thanks though..
Image

Who is online

Users browsing this forum: No registered users and 4 guests