Forum Discussion
4Hobby
Dec 19, 2022Copper Contributor
Use the values returned by COUNTIF in a table and sort them
Hello, if possible, I would like help identifying the formula and/or macro useful for automating the procedure described below: In the lower six areas 'AD33 ÷ AS33, H73 ÷ AB73, H113 ÷ AN113, AD153 ÷...
4Hobby
Jan 07, 2023Copper Contributor
I add the file containing the macro that a friend developed for me, in case it may be useful to someone.
Practically by inserting a group of 6 numbers (in the range 1÷90) in cells A5÷F5 and launching the macro 'Compare'... in row 76 of the sheet 'Table 1' the 'equal' quantities found for single values, pairs of values, triples ... etc up to 9 quantities are returned.
I ask if the same analysis and results can be performed using exclusively formulas - without the use of macros/code-
thank you