Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Overall comments

Hi All,   I have 2 sheets, where, The 1st sheet consists of 5 regions and their data The 2nd sheet consists of the same 5 regions’ comments + 1 Group comment (Combination of all 5 region is call...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Unfortunately we dont have access to share or open any mode of transfer.

 

and we dont have access to send the file through mail as well. This is were i am stuck at.

 

Do you have any idea  what i can do, can i share the screenshot of the sample data?

 

Thanks in advance:)

Anonymous wrote:

HI Anonymous ,

I think you can add if statement with isfiltered function to check if current row contents has been filtered, then you can return correspond comment based on compare result.
If you still confused to coding formula, please share some sample date for test.

Regards,

Xiaoxin Sheng

Anonymous wrote:

HI Anonymous ,

I think you can add if statement with isfiltered function to check if current row contents has been filtered, then you can return correspond comment based on compare result.
If you still confused to coding formula, please share some sample date for test.

Regards,

Xiaoxin Sheng

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

You can share some sample data with key fields and fake records and stored to excel file, upload these test sample to onedrive or google drive and share link here.

Notice: do not add sensitive or real data to your sample.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi @v-shex-msft ,

     

    Unfortunately we dont have access to share or open any mode of transfer.

     

    and we dont have access to send the file through mail as well. This is were i am stuck at.

     

    Do you have any idea  what i can do, can i share the screenshot of the sample data?

     

    Can you share mail ID