Log In
Register
Home
Active Member
September 7, 2022
Offline
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.
See AnswerActive Member
September 7, 2022
Offline
And please note and help on the formula by considering the CoCd and Account are in Text format , Not in Numbers .
February 2, 2013
Offline
Hi Revathi
What i understand i have updated in highlighted
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
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)
