Stop copying at 85

[thong127]

Hello all,

I want to copy numbers from sheet1 to sheet2. I want a formula that will copy only up to 85.

1. If the first column has value of greater than or equal to 85 it will stop copying even second column has a lesser value.
2. If the Second column has a value of greater that or equal to 85 it will stop copying even first column has a lesser value.

[AlKey]

Enter formula in B2 and pull it to C2 and then copy down

Please Login or Register  to view this content.

v	A	B	C
1	Time[Hr]	ABC	DEF
2	0	0.00	0.00
3	1	29.33	29.16
4	2	45.80	40.71
5	4	65.30	57.72
6	6	80.46	70.04
7	8		79.14
8	10		85.00
9	12
10	16
11	20

[thong127]

Hi Alkey,

Thanks for the reply. sorry for not making myself clear. I want also that the the columns are equal.

I want also to see (87.92, 91.42).

I would appreciate if you can modify your formula.

Thank you so much.

thong

[AlKey]

I don't think I get it. Do you want everything copied from columns B and C?

Please Login or Register  to view this content.

[thong127]

Hi AlKey,

Thanks for the reply.

Sorry, What I want is the two column should be equal in count.
Image.png
Thanks.

[AlKey]

and count is based on what?

[thong127]

Hello,

Same criteria greater than or equal to 85.

Thanks.

[AlKey]

pull formula to the right and then down

Please Login or Register  to view this content.

[thong127]

Hi AlKey,

Sorry If I'm asking a lot. Is there a way that you can also include to copy the time points in your formula?

Thank you so much.

[newdoverman]

This is confusing but here is my take on the problem. I take it that you want to stop copying if either column B or C reaches 85 or more.
Enter this in Sheet2!B2 and fill across and down

Please Login or Register  to view this content.

	A	B	C
1	Time[Hr]	ABC	DEF
2	0	0	0
3	1	29.32583333	29.16
4	2	45.80100185	40.7123
5	4	65.29619673	57.71949562
6	6	80.458241	70.0388204
7	8
8	10
9	12
10	16

[AlKey]

After you ran formula in B and C use this on in col A

Please Login or Register  to view this content.

[thong127]

Hi newdoverman,

Thank you for the reply. yes I want to stop copying either column B or C reaches greater than or equal to 85.

I tried your formula but it stops me at 80.46 and 70.04.

if you can modify your formula to include the time is highly appreciated and it will be a great help for me.

Thank you.

[AlKey]

Final

Enter formula in A2 and copy down

Please Login or Register  to view this content.

then enter this one in B2 and pull to the right and down

Please Login or Register  to view this content.

v	A	B	C
1	Time[Hr]	ABC	DEF
2	0	0.00	0.00
3	1	29.33	29.16
4	2	45.80	40.71
5	4	65.30	57.72
6	6	80.46	70.04
7	8	87.92	79.14
8	10	91.42	85.00
9
10
11

[newdoverman]

Enter this formula (just the original copied right) in Sheet2!A2 and fill right and down

Please Login or Register  to view this content.

	A	B	C
1	Time[Hr]	ABC	DEF
2	0	0	0
3	1	29.32583333	29.16
4	2	45.80100185	40.7123
5	4	65.29619673	57.71949562
6	6	80.458241	70.0388204

[ChemistB]

Similar to AlKey (except my glass is half empty)
In A2 copied down
=IF(ISNUMBER(B2),Sheet1!$B35,"")

In B2 copied across and down
=IF(OR(Sheet1!$B35<85, Sheet1!$C35<85), Sheet1!B35,"")

[thong127]

Hi AlKey & newdoverman,

Sorry to both of you. I Noticed that We have 87.92 at column B at Hour 8. copying supposed to be stop their because it is greater than 85.

Thanks.

[ChemistB]

I thought you wanted it to continue until both columns were over 85. NewDoverMan's solution should work for you, it stops if either is over 85.

[thong127]

Hi ChemistB,

I'm just wondering I tried NewDoverMan's forumula but it stopped me at Hour 6, suppose to be hour 8.

Thanks

[newdoverman]

You did ask for "I want a formula that will copy only up to 85." 87.92 being greater than 85 will not be included with this criteria. If you are wanting a higher ceiling, what is it?

It seems that you want something a bit different.
I inserted a row on Sheet1 between the data and the headers

	A	B	C
33	Time[Hr]	ABC	DEF
34
35	0	0	0
36	1	29.33	29.16
37	2	45.80	40.71
38	4	65.30	57.72
39	6	80.46	70.04
40	8	87.92	79.14
41	10	91.42	85.00
42	12	92.62	88.15
43	16	93.07	90.25
44	20	92.67	91.15

Then on Sheet2!A2 entered this formula and filled across and down

Please Login or Register  to view this content.

	A	B	C
1	Time[Hr]	ABC	DEF
2	0	0	0
3	1	29.32583333	29.16
4	2	45.80100185	40.7123
5	4	65.29619673	57.71949562
6	6	80.458241	70.0388204
7	8	87.9233715	79.13653852
8
9

[AlKey]

Hi AlKey & newdoverman,

Sorry to both of you. I Noticed that We have 87.92 at column B at Hour 8. copying supposed to be stop their because it is greater than 85.

Thanks.

Please look at your own post#5 and look at my post#13. Are you trying to confuse the entire world?

[newdoverman]

Here is your workbook with the procedures of msg#19 working

[thong127]

Hi Alkey,

Sorry for that...but in my post#5 my purpose is I want to show that the two columns should be equal in counts. That's why I copied your post#1 and fill the value of hour 8 & 10 to column B.

Again, Im sorry for the confusion.

Thanks

[thong127]

Hi newdoverman ,

Is there a way that I can use your formula without inserting a row between the data and the headers?

Thank you.

[newdoverman]

This appears to work with your example data
Enter in Sheet2!A2 and fill across and down

Please Login or Register  to view this content.

[thong127]

Thanks Newdoverman!

[newdoverman]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.