Concentrate values

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear All

i have in a sheet 15 columns
and almost a thousand lines
in the first column i have some titles with the name TOT
in the column C i have numbers which cross with the TOT

I want in column F to concentrate all the TOT one by one
and in the column G to bring the number of each TOT

I though to use the VLookup function, which bring me the
TOT. The problem is that it can not bring the second TOT,
the third TOT etc.
There is anyway that i can make the vlookup to bring the
one TOT,then the second TOT, ... the last TOT?

Or there is any other way to do this?
If not can i use visual basic, and if yes there is anyone
help me?

Thanks in advance
Manos
 
Manos

You could try AutoFilter, from Data / Filter. Set the filter to Custom and
input your criteria of *TOT*
A count of the items will be given in the status bar.

Andy.
 
I need to use formula because i have asked to be possible
to transfer TOT to another sheet.
Thanks a lot Andy
 
Hi

Have a look at Advanced Filter. With this you can copy your filtered list to
another location.

Andy.
 
I need to collect some specific rows (TOT) to another
column of the sheet but in different place, different row.
That is the main problem

If for example i have TOT1 in A5
TOT2 in A7
TOT3 in A15
TOT4 in A27

i have to go to F35 and Birng the TOT1 and TOT2 in F36
and athe same time to see G35 and G36 the values
i can not use equal because the TOT values change as rows
and i want to have it as groups

Can i use the vlookup functions and each time to search
from different rows, like to jump the row that have found

Regards Manos
 
Back
Top