Hello everyone! 

I was wondering if you knew how to help me find an appropriate excel formula. 

Is there a formula like SUBTOTAL, but that returns the visible text value from a filtered table? Here is the situation. 

Basically, I am exporting a list of survey results from clients on Google forms (pg. 1). I then have written an IF() formula to calculate their personality profile score on (pg 2). 

However, I have filtered the IF()formula with a table so I can only see one individual’s survey at a time. Because the IF() formula references 1 specific cell, I have to rewrite the whole formula every time I want to calculate a different individual’s survey results. Is there a way to filter the survey results and have excel give me the text value from only the visible result of a table search? 

This is the list of Survey results. I will then use the IF() formula on a separate page to convert the survey answer to a numeric value which is used in a formula to determine a result. Is there a way to create a filter for the table on page 1 that only shows the visible cells that you searched for? 

​Hello everyone! I was wondering if you knew how to help me find an appropriate excel formula. Is there a formula like SUBTOTAL, but that returns the visible text value from a filtered table? Here is the situation. Basically, I am exporting a list of survey results from clients on Google forms (pg. 1). I then have written an IF() formula to calculate their personality profile score on (pg 2). However, I have filtered the IF()formula with a table so I can only see one individual’s survey at a time. Because the IF() formula references 1 specific cell, I have to rewrite the whole formula every time I want to calculate a different individual’s survey results. Is there a way to filter the survey results and have excel give me the text value from only the visible result of a table search?  This is the list of Survey results. I will then use the IF() formula on a separate page to convert the survey answer to a numeric value which is used in a formula to determine a result. Is there a way to create a filter for the table on page 1 that only shows the visible cells that you searched for?    Read More

​