Home

How to select specific cells among thousands of cells that are in one column?

%3CLINGO-SUB%20id%3D%22lingo-sub-321659%22%20slang%3D%22en-US%22%3EHow%20to%20select%20specific%20cells%20among%20thousands%20of%20cells%20that%20are%20in%20one%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321659%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20in%20summary%20of%20the%20problem%20i%20am%20having%20is%20as%20follows%3A%3C%2FP%3E%3CP%3E-%20I%20have%20one%20column%20that%20contains%20thousands%20of%20cells%20(data)%3B%3C%2FP%3E%3CP%3E-%20what%20i%20want%20to%20achieve%20is%20the%20average%20of%26nbsp%3Bsome%20specific%20cells%20in%20the%20column%3B%3C%2FP%3E%3CP%3E-%20my%20problem%20is%20that%20i%20cannot%20select%20one%20by%20one%20as%20it%20is%20impossible%20and%20they%20are%20not%20any%20type%20of%20order%3B%3C%2FP%3E%3CP%3E-%20what%20i%20have%20is%20the%26nbsp%3Brow%20number%20(e.g.%20604%2C%201122%2C...%2C)%20and%20the%20column%20letter%3B%3C%2FP%3E%3CP%3E-%20I%20want%20to%20take%20the%20average%20of%20these%20cells%20without%20taking%20in%20consideration%20the%20others%20in%20the%20same%20column%20(e.g.%20how%20to%20pick%20these%20cells%20automatically%20since%20i%20know%20their%20column%20letter%20and%20their%20row%20number)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20excel%20file%20is%20attached%20%3A%3C%2FP%3E%3CP%3EColumn%20A%20is%20the%20data%20column%2C%20where%20i%20want%20to%20take%20the%20average%20from%3C%2FP%3E%3CP%3EColumn%20C%20is%20the%20row%20numbers%26nbsp%3Bof%20the%20cell's%20that%20i%20want%20to%20the%20average%20of.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20kind%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3ESalam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321659%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321673%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20select%20specific%20cells%20among%20thousands%20of%20cells%20that%20are%20in%20one%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321673%22%20slang%3D%22en-US%22%3ENext%20to%20your%20data%2C%20in%20column%20B%2C%20starting%20from%20cell%20B1%2C%20enter%20this%20formula%3A%3CBR%20%2F%3E%3DIF(ISERROR(MATCH(ROW()%2C%24C%241%3A%24C%242762%2C0))%2C0%2C1)%3CBR%20%2F%3ECOpy%20down%20to%20match%20the%20data%20in%20col%20A.%3CBR%20%2F%3EIn%20Any%20cell%2C%20enter%20this%20formula%20to%20average%20the%20numbers%3A%3CBR%20%2F%3E%3DAVERAGEIF(B1%3AB48482%2C1%2CA1%3AA48482)%3C%2FLINGO-BODY%3E
Okello90
Occasional Visitor

Hello All,

 

Just in summary of the problem i am having is as follows:

- I have one column that contains thousands of cells (data);

- what i want to achieve is the average of some specific cells in the column;

- my problem is that i cannot select one by one as it is impossible and they are not any type of order;

- what i have is the row number (e.g. 604, 1122,...,) and the column letter;

- I want to take the average of these cells without taking in consideration the others in the same column (e.g. how to pick these cells automatically since i know their column letter and their row number)

 

The excel file is attached :

Column A is the data column, where i want to take the average from

Column C is the row numbers of the cell's that i want to the average of.

 

Thank you very much for your kind help.

 

Kind regards,

Salam

1 Reply
Next to your data, in column B, starting from cell B1, enter this formula:
=IF(ISERROR(MATCH(ROW(),$C$1:$C$2762,0)),0,1)
COpy down to match the data in col A.
In Any cell, enter this formula to average the numbers:
=AVERAGEIF(B1:B48482,1,A1:A48482)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies