?

Log in

No account? Create an account

Previous Entry | Next Entry

Excel is kicking my ass...

I am trying to figure out how to count a value in excel.

I have email addresses for customers and dates of transactions - about 25,000 customers, and over 60,000 lines of data. I need a countif formula that tells excel to count the email address if there is more than one transaction on the same date. Every transaction line has a unique date.

I have spend all day trying to figure this out, and my boss just told me that it was challenging (I think he's humouring me) and to go home, that we would figure it out tomorrow.

It's so frustrating because I wanted to have this done for him today. He needs it for a presentation next week and I feel like I'm really letting him down.

ARGH! H8H8H8H8!

Tags:

Comments

mdlbear
Jul. 15th, 2011 04:18 am (UTC)
Don't know anything about Excel, thankfully. But it sounds like a useful restatement of the problem (if I understand it correctly) might be:

for each email address, count the number of times that email address is involved in more than one transaction on the same day.
shaddyr
Jul. 15th, 2011 06:00 am (UTC)
for each email address, count the number of times that email address is involved in more than one transaction on the same day.

That is exactly what I am trying to do! But I can't figure out a countif formula with the right variables to screen for dates.

*sigh*
redaxe
Jul. 15th, 2011 12:27 pm (UTC)
Maybe you don't need a countif. You could do a simple count: set a counter to 1 for the first transaction date for an email address, then move to the next line and compare values. If identical, increment a counter. If not, set a new counter for the new date value, and iterate. When you're done, you can do a simple search for counter values >1.

This seems a bit complex for one statement in Excel, but I'm pretty certain that it can be done using Excel's functions. A bit brute-force, I'm afraid. Sorry 'bout that, Chief.
shaddyr
Jul. 20th, 2011 01:31 am (UTC)
It worked - I got a count of what I needed and that's all I cared about!

Thanks!

Profile

Geek by Shaddyr
shaddyr
Shaddyr

Latest Month

May 2019
S M T W T F S
   1234
567891011
12131415161718
19202122232425
262728293031 

.

Tags

Page Summary

Powered by LiveJournal.com
Designed by Tiffany Chow