Forum Discussion
Repeating last calculated value
Hi All,
Need help with formula for calculating below Companylist Column which is nothing but repeating Company Name and if field is blank then says "No Company".
| ID | Company | Companylist |
| 309703748 | No Company | |
| 309703748 | No Company | |
| 309703748 | No Company | |
| 309703748 | No Company | |
| 309703748 | No Company | |
| 309703748 | No Company | |
| 309703748 | No Company | |
| 309703748 | Finserve Ltd | Finserve Ltd |
| 309703748 | Finserve Ltd | |
| 309703748 | Finserve Ltd | |
| 309703748 | Enable India corp | Enable India corp |
| 309703748 | Enable India corp | |
| 309703748 | Enable India corp | |
| 309703748 | Enable India corp | |
| 309703748 | LTI | LTI |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI | |
| 309703748 | LTI |
Excel formula is :
=IF(A2<>A1,IF(B2="","No Company",B2),IF(B2<>"",B2, C1 ))
3 Replies
Hi surajde,
According to your description, I think this should be more related to data transformers requirements.
You can enter to 'query edit' and use fill down feature to fill this blank part after the existed values, then use replace function to replace the remain blank part to "No company".
Fill values in a column - Power Query | Microsoft Learn
Replace values and errors - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi Anonymous, thanks for the alternate work around but the method you mentioned is for existing raw data and not for calculated column. I want to write a formula that will do this
Anonymous ,
This one is not working. Can you please check?
Important: When ID changes then it should again start with "No Company" if Company name is blank again that record
