S
stevieboy1313
I need a formula that will, for example, if F4 on Worksheet 1 is >49999, it
will display the entire row 4 on another worksheet?
will display the entire row 4 on another worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Excelenator
Where on the worksheet should the row appear? If it is row 4 in the
original is it ok for it to be row for in the target worksheet? If so
you can use a very simple IF statement as an array formula. The
formula would be something like this
=IF(Sheet2!$D2>49999,Sheet2!A2,"") entered into cell A2 on the target
worksheet and entered using CSE (Ctl-Shft-Enter). Then you can copy
this formula to all the cells and rows in the target sheet and only the
rows that meet the criteria will appear.
original is it ok for it to be row for in the target worksheet? If so
you can use a very simple IF statement as an array formula. The
formula would be something like this
=IF(Sheet2!$D2>49999,Sheet2!A2,"") entered into cell A2 on the target
worksheet and entered using CSE (Ctl-Shft-Enter). Then you can copy
this formula to all the cells and rows in the target sheet and only the
rows that meet the criteria will appear.
S
stevieboy1313
Well, I'll have the target worksheet formatted the same, but when I tried
that formula, it only displays the first column in the target, instead of the
whole row. I have all the cells listed in the formula, but they don't show.
that formula, it only displays the first column in the target, instead of the
whole row. I have all the cells listed in the formula, but they don't show.
E
Excelenator
Once you enter the formula in cell A2 you have to copy it to all rows
and columns of your data. If your original data is in cells A2:G30
then you have to copy the formula to cells A2:G30 in your target
worksheet as well.
and columns of your data. If your original data is in cells A2:G30
then you have to copy the formula to cells A2:G30 in your target
worksheet as well.
S
stevieboy1313
OK, I don't think that will get me what I need anyway. I need a formula that
says, "hey, the data entered in D6 is =/> 50,000, so I need to copy all of
Row 6 onto another worksheet". Is that possible? It seems like it would be.
But I think that the formula needs to be in D6, and not in the other
worksheet.
says, "hey, the data entered in D6 is =/> 50,000, so I need to copy all of
Row 6 onto another worksheet". Is that possible? It seems like it would be.
But I think that the formula needs to be in D6, and not in the other
worksheet.