Forum Discussion

Khanh_Mai's avatar
Khanh_Mai
Copper Contributor
Jul 05, 2020

Please Help: How to find all cells those value are resulted from other cells

Hello,    I have a workbook that contain both numeric number in constant and formula. My problem is I want to find all the cells those value are resulted from other cells. Please see the below exam...
excel
Formulas and Functions
Charla74's avatar
Charla74
Iron Contributor
Jul 05, 2020

Khanh_Mai 

 

You can use the Trace Precedents / Dependents function from the Formula tab, which adds an arrow for formula linked to another cell: 

 

 

https://www.extendoffice.com/documents/excel/3402-excel-trace-dependents-multiple-cells.html

  • Khanh_Mai's avatar
    Khanh_Mai
    Copper Contributor
    Aug 17, 2020

    Thank you for your help, Charla74, It is useful. 

     

    But it doesn't work I desired. Is there any way to get the answer to my question like the "Find & Replace" function works: First, select the range and then select only the cells those values are resulted from other cells. 

    Many thanks. 

Resources