Home » Forums » Open Source Learning Center » Question and Answer

Need Help on Multiple Column/Row Comparision and Count

Submitted by C3212625 on 16 December, 2013 - 10:47

Dear Experts

I need some help/advice on comparing and counting mutiple Rows/Columns

I have 3 Columns as per the attached Image

Nos No1 Count

need to compare "Nos" column with "No1" and print the count on Column "Count"

Tried with counfif() function, which is working fine. However When i Copy the folumula to next column the range is changing and giving me incorrect result.

Please Help on this.,Thanks

Excel Help
‹ Identifying a ranked value and then displaying a value Filter problems ›
»
Almir's picture

Change references from relative to absolute

Submitted by Almir on 22 December, 2013 - 14:45.

I guess it is due to relative referencing. You need to make references absolute.

If you formula in C2 is like:

=COUNTIF(B2:B50, A1) - for example, you try to count values from A1 in the range B2:B50,

you need to make it:
=COUNTIF($B$2:$B$50, $A1)
So, when you copy your formula down or right, range will not change, because it will always reference to the same cells.

»

Thanks Almir

Submitted by C3212625 on 23 December, 2013 - 09:19.

Hi Almir

My Issues Fixed., Thankyou..

»
Almir's picture

Glad to help you.

Submitted by Almir on 23 December, 2013 - 14:52.

Glad to help you.

»