Active Member
September 7, 2022
Hi Team,
Could you please help us on the alternate formula to match the Positive negative values based on the CoCd(Column A) & Account (Column B) .
attached spread for your reference, where the account and Cocd is same then can use the formula applied in Sheet Individual accounts.
if the all the lines are at consolidated as in sheet Consolidated sheets, the same formula will not be work ,
so the Concat has been used for CoCd, Account and Amount and applied the formula. could you please help with any alternate formula without using concat.
Moderators
January 31, 2022
Hi,
In D2 on the "Consolidated" sheet, you can use this formula:
=IF(C2="","",A2&B2&"/"&ABS(C2)&"_"&COUNTIF(C$2:C2,C2))
and copy it down.
This combines the concatenated values from A and B with the absolute value in C and adds the counter. And now it doesn't matter if the account numbers are numeric or alpha-numeric. Revised your file. See attached.
Riny
Answers Post
1 Guest(s)