Count multiple values in another Column
Closed
Ebejer
-
Sep 22, 2010 at 05:53 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 23, 2010 at 06:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 23, 2010 at 06:50 AM
Related:
- Count multiple values in another Column
- How to lasso multiple objects in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- How to count names in excel - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 23, 2010 at 01:00 AM
Sep 23, 2010 at 01:00 AM
quotes
In Sheet1 I have a column with a multiple numbers
In sheet1 A1 contains 1,3,5
unquote
this is confusing.
I take it in sheet 1
a1 is 1,A2 is 3 and A3 is 5
and in sheet 2 cells A1 to A7 contains nos 1 1 1 2 3 4 5 respectively
in that case in sheet 2 in B1 (or in any empty cell) copy this formula
=COUNTIF(A1:A7,Sheet1!A1)+COUNTIF(Sheet2!A1:A7,Sheet1!A2)+COUNTIF(Sheet2!A1:A7,Sheet1!A3)
you will get 5
modify this to suit you.
In Sheet1 I have a column with a multiple numbers
In sheet1 A1 contains 1,3,5
unquote
this is confusing.
I take it in sheet 1
a1 is 1,A2 is 3 and A3 is 5
and in sheet 2 cells A1 to A7 contains nos 1 1 1 2 3 4 5 respectively
in that case in sheet 2 in B1 (or in any empty cell) copy this formula
=COUNTIF(A1:A7,Sheet1!A1)+COUNTIF(Sheet2!A1:A7,Sheet1!A2)+COUNTIF(Sheet2!A1:A7,Sheet1!A3)
you will get 5
modify this to suit you.
Hi Venkat,
Thanks for your response. I did wonder how clear my explanation was.
Quote
this is confusing.
I take it in sheet 1
a1 is 1,A2 is 3 and A3 is 5
and in sheet 2 cells A1 to A7 contains nos 1 1 1 2 3 4 5 respectively
Unquote
No sorry in sheet1 cell A1 contains 1,3 & 5 in the same cell (then Cell A2 may contain 2 & 3 in the same cell).
and yes in sheet2 cells A1 to A7 contain no. 1 1 1 2 3 4 5 respectively.
I don't know if this is posible but any help or a work around would be great!
Thanks again
Matt
Thanks for your response. I did wonder how clear my explanation was.
Quote
this is confusing.
I take it in sheet 1
a1 is 1,A2 is 3 and A3 is 5
and in sheet 2 cells A1 to A7 contains nos 1 1 1 2 3 4 5 respectively
Unquote
No sorry in sheet1 cell A1 contains 1,3 & 5 in the same cell (then Cell A2 may contain 2 & 3 in the same cell).
and yes in sheet2 cells A1 to A7 contain no. 1 1 1 2 3 4 5 respectively.
I don't know if this is posible but any help or a work around would be great!
Thanks again
Matt
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 23, 2010 at 06:50 AM
Sep 23, 2010 at 06:50 AM
one more problem, in A1 do you have 135 or 1,3,5. if you have 135 there will be problem. suppose you have 1329 is it 1,3,29 or 1,3,2,9
if you have 1,3,5 then it is easy because you have to convert it to text to columns by manipulating data-texttocolumns using comma as delimiter . in that case
a1 will become1,b1 will becoming 3, c1 will become 5
and the same formula given earlier with some modification can be used.
what is it. comma is there (or at least space is there)
if you have 1,3,5 then it is easy because you have to convert it to text to columns by manipulating data-texttocolumns using comma as delimiter . in that case
a1 will become1,b1 will becoming 3, c1 will become 5
and the same formula given earlier with some modification can be used.
what is it. comma is there (or at least space is there)
