Look up Formula Challenge

[kelly mort]

I have a worksheet that starts from column D1 to column S1 down. Column D contains IDs that I use to look up the data to this sheet. Column O contains values which may be positive, negative or blank. I now wanna separate the positive and negative numbers to different sheets. So with the positive numbers, I want then arranged in descending order and the negative numbers in ascending order.


These are the sheet names

Datasheet
Positive Values
Negative Values

I wish I could post a screen shot here but I have issues doing that with my pc.


I hope I am clear enough to be understood.

Thanks in advance
Kelly

 

[Fennek]

Hello,

maybe a bit simple, but it should work:

- a helper column with the function =abs()
- autofilter
- copy

regards

 

[Aladin Akyurek]

What is the motive for creating two sheets for the same data if whatever you want can be done with the data sheet that you now have?

 

[kelly mort]

My motive is to have only positive values filtering to one sheet and negative to the other.

Regards
Kelly

 

[kelly mort]

@Fennek, I am lost. What actually do you mean?

Regards
Kelly

 

[Aladin Akyurek]

My motive is to have only positive values filtering to one sheet and negative to the other.

Regards
Kelly

The question is whether that is really necessary if all of the queries you have can be done with a single sheet. So, what is your real question?

 

[kelly mort]

Haha. I am confused.

Yes all queries are on one sheet. But what I want to do is to separate them to different sheets based on values in column O. I don't know if this is clear now. If the is a better way you can let me know
Regards

 

[Aladin Akyurek]

Haha. I am confused.

Yes all queries are on one sheet. But what I want to do is to separate them to different sheets based on values in column O. I don't know if this is clear now. If the is a better way you can let me know
Regards

Do you have any question that requires having two sheets in order to be answered instead of just one besides the splitting question itself?

 

[kelly mort]

Can I use two sheets for the data sheet?