Some help with a Excel Sheet.

[Ron Branch @ 5th Axis]

Anyone got experience filtering in Excel when there is 10 and 1. Problem is trying to get a filter to see 10 and not 1 when it is filtering values. Anyone got some suggestions or ideas how you could go about this when using and template file?

 

Thanks for any suggestions ideas or tips.

[Dave.L]

Ron,

 

I am not 100% sure, but have you formated the cell?

[Tim Johnson]

If you're searching a column click the column select Data, Filter, Auto Filter. On the top row you will see a list box icon (Down arrow button). Click the button select "10" and only the rows with the 10 will show up.

[Leandro]

Ron as Dave wrote the format is important. however you can create a formula in another cell to change it. And then filter in this other column.

If you prefer send the xls to me, may be i cann help.

[Ron Branch @ 5th Axis]

Well imagine you have data fields from one piece of collected data you then want to filter coming in. That data has point_1, point_2, and all the way up to point_100. Excel sess point_1 and point_10, point_11 and so forth as all the same thing when using their standard filtering methods. We take the point_1 and then put into a Excel graph. When the graph sees point_1 it puts that and point_1o to point_19 in the same place not filtering them correctly. I am trying to get that to filter point_1 to the same place on the chart and point_10 to the same place on the chart for point_10 and now it does not.

 

Trying to get this problem sorted out and everything we try keep messing up to the point_10 and so forth.

 

Now the next problem. If thw information comes in Point_11 then point_2 then point_33 excel also gets lost because it was not collected in the order the reports want to see it. We want the report to see that arrange it correctly then use it to the fill out the chart any ideas to accomplish that. I know Zoober(Robert) was doing something like this on his X+ with tool numbers so I think it is possible, but not sure how to accomplish what might be an easy task for someone who know Excel much better than I do.

[LaszloK]

Problem may be that it is a "label" instead of a "number". If it was just 1,2,3 instead of point_1, point_2, point_3 it would sort properly.

[Toonz]

If I understand the problem correctly, instead of using digits 1 thru 9, use 01 thru 09. Then there should be no issues filtering for 10's and not finding 1's.

[Ron Branch @ 5th Axis]

Thanks for the tips. I will let you know what we come up with.