0

How can I pull all the items in a range to list those in a single column? Repeating items can take place only ones. There might be numbers and texts in the cells

Thanks Best

Figure

Scott Craner
  • 148,073
  • 10
  • 49
  • 81
Bekir Şahin
  • 5
  • 4
  • see: https://stackoverflow.com/questions/62204826/excel-unique-across-columns/62205206#62205206 – Scott Craner Jun 12 '20 at 16:52
  • @ScottCraner - was literally going to add a plug to the same answer :-) – BigBen Jun 12 '20 at 16:52
  • @BigBen how can you help me with this question? https://stackoverflow.com/q/62311242/8950875 – Bekir Şahin Jun 12 '20 at 17:07
  • 1
    You should probably use VBA, as mentioned already in a [comment](https://stackoverflow.com/questions/62311242/how-to-find-directional-roots-of-a-tree-using-excel#comment110263720_62311242). – BigBen Jun 12 '20 at 17:08
  • @BigBen I added the VBA as a keyword to the question. Am I doing correct or do I need to ask this question again? Thanks – Bekir Şahin Jun 12 '20 at 17:24
  • You would need to include the VBA you already tried.... SO is not meant to be a code-writing service. – BigBen Jun 12 '20 at 17:31

0 Answers0