t12

Hi Everyone, I've posted a similar question, but am having new troubles. One column has 4 values, T12, T8, empty cells, and #VALUE !. The second column has values 1 through 4. The new column needs to take the value from the second column (numbers 1-4) and match it to a title. For example, if...

So, I want to create a Pivot table that displays DELIVERY DATE, sum of RUN#, sum of ORDER#, sum of ORDER AMOUNT, calculates RUN TIME (using DISPATCH TIME & RETURN TIME) in one or two Pivot Table(s). I am having a tough time figuring it out. Data sample is below that I import into a table from...

Good afternoon everybody. I have a very large spreadsheet which contains around 2000 rows, the first six columns of which are master data. Thereafter, there is a number of six-column blocks that contain "sets" of transactional data. All rows have at least one six-column block, some have more...

I am trying to filter the following T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12 T13 T14 .......... When I filter A-Z I get T1 T10 T11 T12 .......... T19 T2 T20 I can't put a 0 in fount of the single digit because I need that exact number as is. Anyone have this problem or any suggestions? Thanks...