0

I have a data with 5824 elements. The values in this data set repeats with certain period. I would like to find the data with a specific value in this data set. Then I would like to copy these cells which contain the specific values, to another cells. Could you help me how to do that in Excel?

Kind regards

Ulugbey
  • 21
  • 5
  • Can you show what your data look like (not all 5824, of course), and can you show what you have already tried? Are you looking for a formula (like based on `Match()`, `VLookup()` or others) or are you looking for a VBA macro? In case of a macro, did you already try recording and adapting one? What does it look like? ...? – Dominique Apr 15 '22 at 12:57

1 Answers1

0

Without seeing the data this is difficult to answer, but let me try. There are some different methods to do this general thing.

In excel there is filters application, table filters, and the filter equation.

filter equation example =FILTER(A2:C6,B2:B6="S1")

There are other excel equations that good for this like =xlookup() video_1 and video_2. Additional options are Index(,Match(,,)) and vlookup(), Sumifs(), ...etc.

Another way to do this is with the Power Query tools that are in excel. (I do recommend the Excel_on_fire videos from years 2017-2019, not linked)

  1. Get bitcoin price off the web
  2. From another worksheet
  3. Scrap the web
Shane S
  • 1,747
  • 14
  • 31