Wacky IF Structire
 

It never ceases to amaze me the solutions I find in these forums. I find
I;m posting about a question a week, and I have gotten some absolutely
amazing answers. If one of you who have helped me before happens to
come across this post as well, I just wanted to take a moment and say
THANX!!!!


On to business, though. On the Daily Tracker sheet, my screener lists
off every single ticket that he deals with. Column A is the ticket
number, B is the reps name, C is the category, D is a CB indicator, E
indicates if the ticket is a valid claim, and F for a description.

Now, on another work sheet I need it to list off all of the invalid
tickets, but only the ticket number, name and description.

So what I have at the moment is:


In column A, for the ticket number:
=IF('Daily Tracker'!E4:E1000="No",'Daily Tracker'!A4:A1000)

In column B, for the reps name:
=IF('Daily Tracker'!E4:E1000="No",'Daily Tracker'!B4:B1000)

In column C, for the description:
=IF('Daily Tracker'!E4:E1000="No",'Daily Tracker'!F4:F1000)


Now, this works perfectly6, except for one thing. When the ticket on
the Daily Tracker sheet is valid, it is putting the word "FALSE" into
A, B, and C. So, lets say for example that row 4 and 5 were invalid, 6
was valid and 7 was invalid. What I would end up with is:

Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
FALSE -- FALSE -- FALSE
Ticket # -- Rep's Name -- Description


What I am looking for is a way to tell it to skip over those and move
onto the next so it will not give me those "FALSE" lines.

I posted this in the misc thread as well, but no such luck, thought I'd
try it in here as well.

:)

Thanx for all the help!!!


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=555148

Wacky IF Structire
 

I think your problem is that you have only provided an option in the IF
statement for a TRUE outcome - you have not specified what to do for a
FALSE outcome

the correct syntax is =if(condition,reponse if true, response if
false)

Try this =IF('Daily Tracker'!E4:E1000="No",'Daily
Tracker'!A4:A1000*,""*)

this will leave a set of blank lines instead of false. If you want to
skip the lines alltogher, you could try sorting (not sure what that
will do) or else you will need VBA

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555148

Wacky IF Structire
 

You can add an argument for when the condition is FALSE, make this a
blank, i.e. "". BTW, aren't you looking at a single cell for each line?
Try

=IF('Daily Tracker'!E4="No",'Daily Tracker'!A4,"")

and similar for the other formulas


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555148

Wacky IF Structire
 

Okay, so maybe it is the whole formula that I need to change.

On that Daily Tracker sheet there are anywhere from approx 700 - 900
entries daily. 350 - 500 of those will end up on the Invalid sheet.
What I am hoping to deo is get them as a single list with out all the
other stuff inbetween.

So, if I were to follow your advice, then I would end up with something
like:

Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description

Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description



Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description



Ticket # -- Rep's Name -- Description


Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description


So on and so forth. What I would like to have is:


Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description
Ticket # -- Rep's Name -- Description


Much easier to read, count, sort, analuse, etc.

If there is no way to do it, thogugh, I will bow to your expertise and
understand.

Thanx again for all the help!!


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=555148

Wacky IF Structire
 

I'm not sure the exact structure of your spreadsheet, however you could
try using VIEW\CUSTOM VIEWS

Select your main data page
Create a view titled "All Info" or similar
Now make the main sheet look like your summary sheet by
1 set up an Auto Filter to hide the rows that you don't want to see
2 hide the columns that you don't want to see
Create a new view titled "summary"

You can now toggle between the 2

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555148

Wacky IF Structire
 

Worked like a charm!

Thanx a million, Matt!!


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=555148