How to change the sign of number based on condition in same cell in large data

%3CLINGO-SUB%20id%3D%22lingo-sub-1532916%22%20slang%3D%22en-US%22%3EHow%20to%20change%20the%20sign%20of%20number%20based%20on%20condition%20in%20same%20cell%20in%20large%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532916%22%20slang%3D%22en-US%22%3EPlease%20Help%20me%3CBR%20%2F%3EHow%20to%20change%20the%20sign%20of%20number%20based%20on%20condition%20in%20same%20cell%20in%20large%20data%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20use%20Paste%20special%20with%20multiply%20by%20-1%20after%20filter%20than%20it%20change%20take%20place%20in%20invisible%20cell%20also%3CBR%20%2F%3EThank%20you%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1532916%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533122%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20sign%20of%20number%20based%20on%20condition%20in%20same%20cell%20in%20large%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F427829%22%20target%3D%22_blank%22%3E%40Sonu975%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20what%20you're%20asking%20is%20probably%20relatively%20simple%2C%20BUT%20your%20description%20is%20somewhat%20confusing%2C%20so%20rather%20than%20continue%20and%20exacerbate%20the%20confusion%20with%20a%20solution%20that%20may%20not%20fit%20at%20all%2C%20I%20need%20to%20ask%20you%20to%20post%20a%20spreadsheet%20that%20represents%20the%20reality%20you're%20dealing%20with.%20It's%20hard%20to%20describe%20things%20fully%20accurately%20in%20words%3B%20so%20the%26nbsp%3B%20real%20thing%20helps%20a%20lot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20please%2C%20an%20actual%20spreadsheet%20rather%20than%20an%20image.%20If%20your%20real%20one%20includes%20confidential%20information%2C%20then%20post%20a%20file%20that%20takes%20that%20confidential%20info%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Please Help me
How to change the sign of number based on condition in same cell in large data

If I use Paste special with multiply by -1 after filter than it change take place in invisible cell also
Thank you
1 Reply

@Sonu975 

 

I think what you're asking is probably relatively simple, BUT your description is somewhat confusing, so rather than continue and exacerbate the confusion with a solution that may not fit at all, I need to ask you to post a spreadsheet that represents the reality you're dealing with. It's hard to describe things fully accurately in words; so the  real thing helps a lot.

 

And please, an actual spreadsheet rather than an image. If your real one includes confidential information, then post a file that takes that confidential info out.