Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
May 17, 2024
Solved

Filter Issue

Dear Experts,                   Greetings! I have an issue where I need to prepare a set from input sheet to Output sheet, In the "Input" sheet we have New Antenna Id, which can be 1,3,4,7 and eac...
BI & Data Analysis
excel
Formulas and Functions
power bi
  • HansVogelaar's avatar
    HansVogelaar
    May 17, 2024

    anupambit1797 

    I have attached a formula solution. I had to convert the table on the second sheet to an ordinary range, and to convert the text values1, 3, 4 and 7 in A1:D1 to numbers.

anupambit1797's avatar
anupambit1797
Iron Contributor
May 25, 2024

Thanks peiyezhu , honestly I am not aware of SQL and the traditional sw computer languages.

 

Br,

Anupam

Resources