Pelican Parts Forums
Page 2 of 2 « Prev 1 2
Show 40 post(s) from this thread on one page

Pelican Parts Forums (http://forums.pelicanparts.com/)
-   Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)
-   -   Need an Excel Guru (http://forums.pelicanparts.com/off-topic-discussions/893771-need-excel-guru.html)

Bob Kontak 12-06-2015 01:13 PM
Quote:
Originally Posted by M.D. Holloway (Post 8904593)
I know it can be down. I remember in grad school with a very old version I did macros to do something like this. It must be simpler now. I just never mess with it.
There is a function where you can take column data and convert to rows.

Happy for you to e-mail me. We can talk on the phone and I can more than likely pull it off for you.

If it's an onerous set of data, I can get a handle on what you need. Perform some due diligence to ensure it can be done and teach you.

If it's a couple hour job, I can do it.

23 years as an operational accountant.

Paul T sounds viable as well.

Will PM you my e-mail.

72doug2,2S 12-06-2015 04:03 PM
You can do this on this thread and get several options to do the same thing. What I would want to know is what is the most efficient solution. No reason to PM.

Bob Kontak 12-06-2015 05:16 PM
Quote:
Originally Posted by 72doug2,2S (Post 8906826)
You can do this on this thread and get several options to do the same thing. What I would want to know is what is the most efficient solution. No reason to PM.
Ok. Once the speed bump is articulated, fine.

Here is what you have to go on.

Quote:
Originally Posted by M.D. Holloway (Post 8904591)
The data in the rows has to parse to the date of the other spread sheet columns.
This means the data in the rows has to be parsed to allow linkage to the sister spreadsheets. You know that. Data still has to be linked, the hard way.

We don't have (understand) the basis for doing that yet.

MBAtarga 12-06-2015 05:55 PM
My solution involved use of vlookup. I sent the revised file back to him for him to look at - it was only a partial solution - I didn't complete the spreadsheet because the data was not consistent in terms of labels between the files. He basically needs a table of raw data - where each new set of measurements that is added as another column on the right, converted to be rows of data under columns on another spreadsheet.

Bob Kontak 12-06-2015 06:20 PM
Quote:
Originally Posted by MBAtarga (Post 8906982)
I didn't complete the spreadsheet because the data was not consistent in terms of labels between the files.
If you can work vlookup today, you are seven years ahead of me. Function is the same. I am just rusty.

How inconsistent is the data?

M.D. Holloway 12-06-2015 07:33 PM
Mark,
Sorry I didn't respond sooner. This is exactly what I'm looking for! I can provide a spread sheet map if you will where cells in one equal cells in another if that helps? I will look to get on it in the PM tomorrow.

72doug2,2S 12-07-2015 02:29 AM
Lubey, why not post the screen shots?

Amail 12-07-2015 06:32 AM
Be careful with hlookup and vlookup guys. Data needs to be sorted in ascending order which sometimes is inconvenient. Index-match is the method I use these days - see Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group for a good explanation.

72doug2,2S 12-07-2015 12:34 PM
You also can't use multiple criteria with h/vlookups

Drbraunsr 12-08-2015 06:03 PM
Array formulas are voodoo


All times are GMT -8. The time now is 12:19 PM.
Page 2 of 2 « Prev 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website


DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.