-
All replies
-
Helpful answers
-
Oct 2, 2016 6:41 PM in response to CK Guelphby Wayne Contello,please select a portion of the table in question and post it to this forum so we can test with some of your data
A shot in the dark just in case...
=if(B1="good", A1, "")
this assumes you have the word "good" in cell A1
you can fill this down by selecting the cell with the formula, copy
now select the column, paste
-
Oct 3, 2016 4:09 PM in response to CK Guelphby Barry,Hi CK,
Your formula looks good, but it needs double quotes around 'good' to identify that as a text string.
C1: =IF(B1="good",A1,"")
Copy everything following the = sign.
In Numbers, click on cell C1, type = then paste
Click the green checkmark to confirm the entry.
C1 should now display the contents of A1, or appear empty, depending on the content of B1.
Next step:
Select the cell C1 (single click), Copy.
Select all of column C, Paste
This fills the same formula (with the row adjusted to match the cell containing the formula) into all cells in column C.
Regards,
Barry
-
Oct 3, 2016 7:29 PM in response to Barryby CK Guelph,Thanks Barry, that was the formula I had in there, it didn't work. Still would like to figure out how to do this if it does come up again!
I ended up just SORTED the data which re-organized the info which is what i was trying to do . this made it easier to copy and paste the info into the sections and format I needed it .
thanks anyway,
cheryl
-
Oct 4, 2016 12:18 AM in response to CK Guelphby Barry,Hi Cheryl,
Sorting (or filtering to show only rows with 'good' in column B) are also good methods to view only the data significant to your purpose.
Regarding 'figuring out how to do this (with a formula), take another close look at my previous post. It points out the only thing missing from your version. You were so close, that a close reading and trying it out should get you the rest of the way!
Regards,
Barry
-
Oct 4, 2016 5:16 AM in response to CK Guelphby Wayne Contello,I am curious why my post seems to have been ignored. It provides the direct answer to your question
-
Oct 4, 2016 8:11 AM in response to Wayne Contelloby CK Guelph,My apologies Wayne, I didn't mean to ignore your post - same response to what I wrote to Barry, thanks or the tip, i haven't tried the formula yet as I ended up reorganizing the data through sorting.
Thanks for the quick response!
-Cheryl
-
Oct 4, 2016 8:15 AM in response to CK Guelphby CK Guelph,Your formula worked...i swear i did that in the several times i tried..apparently not! thanks!