PDA

View Full Version : check for the values in the sheet 2 and count the values



sindhuja
03-07-2009, 10:53 PM
Hi,

Here is my requirement…

I have an excel with some sample data…
I want the counts of all the accounts with the below criteria excluding the accounts in the sheet 2. Also want the counts in the sheet 3.

< -100k , (-100k) to (-500k) , > -500k , 100k to 500k , >500k

Also another set of account to be distinguished separately from others.
Search for the accounts – corresponding subtotal and the cell value next to the subtotal cell…

Am not sure whether this can be done using macro… any help on this will be highly appreciated..

Immediate help will be highly helpful…

-Sindhuja

mdmackillop
03-08-2009, 03:07 AM
This would be simpler if your Column A data on sheets 1 and Columns A, C on sheet 3 were split into separate columns. Can you rearrange it in this fashion or do you have to work with it as presented?

Which column is providing the criteria for the count?

Bob Phillips
03-08-2009, 04:07 AM
If you add a helper column with a header and a simple formula of

=TRIM(LEFT(SUBSTITUTE(A4," ",REPT(" ",100)),200))

and then you could pivot it.

sindhuja
03-10-2009, 03:50 AM
Hi..

I will be working the way i presented.. For the counts i will be using the column A in sheet 1 provided i have to exclude the Column A values in sheet 2 . And the count to be entered in Sheet 3 - Column B.

Hope i made it clear....

-Sindhuja

sindhuja
03-16-2009, 10:19 AM
Any help on this will be highly helpful.... pls..

sindhuja
03-24-2009, 01:25 PM
Hi All,

This is something very urgent... any hand on this will be highly appreciated.

-Sindhuja

Aussiebear
03-24-2009, 01:47 PM
Did you try XLD's suggestion?

sindhuja
03-25-2009, 08:21 AM
Yes……..I tried XLD’s sugessions.. but its not giving me the results I expected…

Aussiebear
03-25-2009, 02:54 PM
Post a worksheet with some dummy data on sheet 1 & on sheet 2 the layout as you require it to be

sindhuja
03-26-2009, 07:04 AM
Hi...

Have already attached the sheet with dummy data's.

-Sindhuja

sindhuja
04-05-2009, 11:53 PM
Any help on this pls....

Bob Phillips
04-06-2009, 01:06 AM
Post the example with my formula, with the pivot (you said you tried it), and then tell is in what way it fails to meet your needs.