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.
And please note and help on the formula by considering the CoCd and Account are in Text format , Not in Numbers .
Hi Revathi
What i understand i have updated in highlighted
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
Thank you Riny, It works.
