Display values of other cells if one cell value is greater than

**raginiy** · 06-04-2010, 03:04 AM

Hi There,

I have two sheets.

Sheet one has values in Column A(text), ColumnB(text) and column C(Number)

In Sheet two I want to display values of column A and column B IF Column C value is greater than 90.

Your help is greatly appreciated.

Thanks,
Ragini

**royUK** · 06-04-2010, 03:17 AM

Why not just custom autofilter Column C?

**raginiy** · 06-04-2010, 03:30 AM

I want the values to be displayed in Sheet2 automatically. When column C is greatern than 90 I want column A and Column B values along with column C.

**royUK** · 09-29-2010, 01:30 AM

When my children were growing up they were taught to use the magic word -THANK YOU, not stamp their feet & demand.

Good luck, bad spreadsheet design makes for hard work