babypink2807
New Member
- Joined
- Jul 13, 2015
- Messages
- 41
- Office Version
- 2016
Its the most infuriating issue, I have two lots of numbers in one column I wish to sort then use a forumla. The first lot had the little grteen flag, so converted them by text to numbers all fine. The second lot was from my CRM, whch auto exports to Excel, fine. I copied and pasted the latter in to the 1st excel sheet. There is nothing at all showing the little green flag. I checked the format and all states numbers. But t will NOT sort. When I use it to find duplicates by using conditional formatting it wont pick ones up it should. I have tried text to column, the 2nd set of data is all at the bottom it will not sort Interestingly when I do apply the duplicate conditional formatting it only shows up in the 2nd set of data and not the 1st
The original data is in black, to distinguish between the two sets the 2nd set is purple. Which I thought should not make a difference. Originally I tried a VLOOKUP and its only then I realised there was something wrong
The original data is in black, to distinguish between the two sets the 2nd set is purple. Which I thought should not make a difference. Originally I tried a VLOOKUP and its only then I realised there was something wrong