I have a basic question. In a doc I want to extract a value from a table based on a specific criteria.
column A where column C= “X”
I am trying with filters but I did not succeed to retrieve only the column A. the filter gives me the full row and if I am adding a .columnA at the end it gives me all values and not the filtered ones.
I found a work around by spliting. I am doing a formula to filter and then I am calling the formula.columnA but I wonder if I can do it once
thanks for your help