N
nevi
It never ceases to amaze me the solutions I find in these forums. I fin
I;m posting about a question a week, and I have gotten some absolutel
amazing answers. If one of you who have helped me before happens t
come across this post as well, I just wanted to take a moment and sa
THANX!!!!
On to business, though. On the Daily Tracker sheet, my screener list
off every single ticket that he deals with. Column A is the ticke
number, B is the reps name, C is the category, D is a CB indicator,
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 invali
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 o
the Daily Tracker sheet is valid, it is putting the word "FALSE" int
A, B, and C. So, lets say for example that row 4 and 5 were invalid,
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 mov
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'
try it in here as well.
Thanx for all the help!!
I;m posting about a question a week, and I have gotten some absolutel
amazing answers. If one of you who have helped me before happens t
come across this post as well, I just wanted to take a moment and sa
THANX!!!!
On to business, though. On the Daily Tracker sheet, my screener list
off every single ticket that he deals with. Column A is the ticke
number, B is the reps name, C is the category, D is a CB indicator,
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 invali
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 o
the Daily Tracker sheet is valid, it is putting the word "FALSE" int
A, B, and C. So, lets say for example that row 4 and 5 were invalid,
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 mov
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'
try it in here as well.
Thanx for all the help!!