Help with a formula
Closed
Jean
-
Nov 17, 2009 at 04:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 17, 2009 at 10:06 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 17, 2009 at 10:06 PM
Related:
- Help with a formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 17, 2009 at 10:06 PM
Nov 17, 2009 at 10:06 PM
A61 1
A62 2
A63 3
A64 4
In B61 type this formula
INVOKE THIS FORMULA BY HITTING CONTROL+SHIFT+ENTER
Copy B61 down from B62 to B64
If this is ok post confirmation
A62 2
A63 3
A64 4
In B61 type this formula
=AVERAGE(IF($A$2:$A$60=A61,$B$2:$B$60))
INVOKE THIS FORMULA BY HITTING CONTROL+SHIFT+ENTER
Copy B61 down from B62 to B64
If this is ok post confirmation