Forum Discussion

KennyK360's avatar
KennyK360
Copper Contributor
Jul 17, 2023

Searching multiple worksheets for different numbers simultaneously in Excel

Is it possible to search multiple worksheets for different numbers simultaneously in Excel?  Using CTL-F isn't working for me.    For example, can I search 10 different worksheets all at once for t...
excel
KennyK360's avatar
KennyK360
Copper Contributor
Jul 24, 2023
Sergei, unfortunately I don't have the license to use ExcelScripts...I'll work on that.

Do you know what changes I can make to this formula so it only shows numbers 53 and 71 instead of numbers 21-1500?

=LET(Num,C1,All,SEQUENCE(MIN(Num-21,1479), , 21),Factors,FILTER(All,MOD(Num,All)=0),TRANSPOSE(Factors))

Thanks!
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 25, 2023

KennyK360 

Not sure I understood what is required. Do you mean something like

=LET(
    Num, C1,
    All, {53,71},
    Factors, FILTER(All, MOD(Num, All) = 0),
    IFERROR( TRANSPOSE(Factors), "" )
)

?

 

  • KennyK360's avatar
    KennyK360
    Copper Contributor
    Jul 25, 2023
    Yes, that is perfect ! Thank you so much for all the help Sergei !!

Resources