Search results

Hello, I have been given code numbers similar to above and need to extract the alpha and numeric characters separately. Examples of code numbers as follows; A1.1 A10.1 A10.10 AB1.1 AB10.1 AB10.10 As you can see each field is not fixed so the formula needs to adapt to suit. I have used the...

I'm trying to create a basic Gantt Chart to plan our future workload for our estimating dept. I would like to be able to automatically merge the repetitive cells that contain the same year (ie on row 2) and also automatically merge the repetitive cells that contain the same month (ie on row 3)...

Prasaddn/Faseeh, Thanks for your help. I too have given up on trying to workout using a formula. The sample that I posted is sufficient for my purposes (at this stage). Unfortunately I do not have the luxury of time to work this out! Thanks again. Matt

Hi guys, Sorry about the delay - I thought I might receive an email notifying me of your responses. Faseeh - I have uploaded sample file as per below http://dl.dropbox.com/u/38326386/getpivotdata%20of%20multiple%20items%20from%20pivot%20table%20report%20filter.xlsx prasaddn - I will...

I have a pivot table which shows the weather statistics for the past 50 years (rainfall & temperature). My pivot table has a Report Filter based on Year. I start with a Worksheet called Weather Data where all the raw data is input. From this I have created a Pivot Table and placed this on a...