Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks all for helping. Here are the details and I'll ask the question in a
minute. I have a sheet with sets of 3 columns (ABC, DEF, GHI, JKL and so on) all numeric and no blank cells. To keep it simple let us say that columns PQR is the extent of the sets. Column P is the basis for a horizontal count. Columns Q & R are added together and their total will be the Vertical count. The horizontal count starts from P and counts from right to left as follows ABC=4 DEF=3 GHI=2 JKL=1 MNO=0 PQR. IF P25=3, Q25=3, R25=4 The count would be horizontal from P25 to D25:F25 (set #3). The Vertical count would be (Q25=3 + R25=4)=7. So D25:F25 less 7 = vertical count back to D18:F18. With that said, is it possible to have a formula find D18:F18 based on the earlier parameters, then match D17:F19 with P26:R26 (not D25:F25). I hope this is clear enough Thank you, Luke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
search macro with array | New Users to Excel | |||
Please help on array search & result | Excel Worksheet Functions | |||
search array | Excel Worksheet Functions | |||
Text Search in an Array | Excel Worksheet Functions | |||
Text Search in an Array | Excel Discussion (Misc queries) |