Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name is Andrew, I will do whatever I can to answer your question
would it be possible for me to get a copy of your sheet?
are you still there
I was about to attach the document
please confirm you are still there so I may attach the sheet
please try to attach the sheet
give me a minute to take a look at that
i have the sheet open
so to elaborate a bit more on my question, I'm trying to find out which accts were reported more than 30 days from the "activity date) column B. The column that can give us this answer is column I, however I am struggling to do this. You know which accounts were reported because they have an "XF" in column G and a "1" in column H.
are we using the current date
as in todays date
in relation to the date in column B
no, the relation between dates should be between column B and column E ... column E is the date we reported the status of the account based on the activity received (column B)
i think i got you
column I gives you a count form the activity date (column B) which is the same per individual account-- up to the date the XF was coded and reported (column E)
so I will do the formula for I
yes, i think thats where you should start
which is just
=E2 - B2
so that gives us the number of days
but there was something else you wanted
which is the next part of this
so once we have the number of days?
what did you need next?
well thats the thing we already have the number of days that is already column I
for example looking at row 2
i just created a formula that did that
so now I am confused
can you talk over the phone?
sorry, they do not let us do that
let me try to explain better
you just want to know which accounts are 30 days
im going to send you a smaller data set to work with
let me know when you open it
okay you see in column a, I gave you only 4 individual accounts. now these individual accounts received reporting once a month per the (HDAUDDT) date which is column E
i have the new file open
we reported the activity received on column B .. the activity received is the Pcode 1 column, that is the activity being reported. however what I am trying to identify is: from the date that we received the pcode 1 did it take us more than 30 days to report that status in column E?
column I is giving us the answer, however I am struggling in putting that in a summary format
for example out of all P114 codes it took us greater than 30 days to report their status of XF
does that make sense?
so you want to comapre these pcode values
to the number of days
and basically just have a report
etc in column i
you would want me to list each number of days greter than 30
in column I
for each value in column C
or do we just want a count
for each value in column C and then a count
id llike to understand how to do both
let me see what I can come up with
a pivot table is not working
we will have to try this a different way
yes i found one that will work for you for the count
at least this will give you an idea of how the formula works
and you can apply it to whatever you need
the summary is on sheet 2
let me know if this is what you need
darn, im having a hard time opening it
im still in the network at my office so we have firewall that blocks a lot of sites and transferring of data...
can you send it to my email address?
that I provided in this website? or I can give to you now
they wont let us communcate by email
i can ask them to forward it to you
it may take a while
The only thing I ask is that when you get it and it works
that you come back and rate
so I get paid
if you need any changes
i can take care of that too
does that sound good?
here bookmark this page so you can get back to me
i will step out of chat now to send the file to the customer service department
and they will forward it to you
ok, let me know when you get the file