Member of the Month

KilaTsunami
October, 2024

Online

Welcome to the Newschoolers forums! You may read the forums as a guest, however you must be a registered member to post. Register to become a member today!

Excel Work

profile picture
2_fadez
Posts: 7780 - Karma: 4,183
So I've gotten stuck on something for work in Excel and I'm looking for someone to help me out with it. I figure someone on here knows coding Excel well enough to figure it out, and I'll throw some bills from Paypal to whoever gets it done.
It should be like one line of long code that searches a line for a certain number, then searches down that column for the nearest highest number to a previously calculated one in that original matched number's column, and then when it finds that nearest number, it goes all the way back across that row to report back the first column's number.
Its hard to explain in short, but it should take lookups, index, or match functions. I've also been suggested using a PivotTable, but I know nothing about it and don't have any more patience to learn it.


I'll send more details on what I need exactly done when I send the file, if anyone actually thinks they can actually do it. Bonus if you get it done tomorrow by 5pm.

Help me out NS brahhhhssss. And have some Kate Upton

Jul 17 2014 9:49PM
7 3
profile picture
.FRY.
Posts: 5620 - Karma: 22,859
I'm here for the Kate Upton. that is all.
Jul 17 2014 9:51PM
5 0
profile picture
.MASSHOLE.
Posts: 7408 - Karma: 11,039
You tried v-lookups?
Jul 17 2014 9:54PM
0 0
profile picture
2_fadez
Posts: 7780 - Karma: 4,183
.MASSHOLE.You tried v-lookups?


combination of vlookups and hlookups. I just got frustrated after several hours and said fuck it. Remember, I need someone to also be able to implement into the code a 'nearest higher value setting' when completing the second part of the search, when it goes down a column of increasing values. Thats a part that I still haven't found an answer for either.
Jul 17 2014 9:58PM
0 0
profile picture
AT-AT
Posts: 3281 - Karma: 3,256
I work in excel all the time. However, i do not know how to do any of the "coding" like aspects of it. Sorry man
Jul 17 2014 9:59PM
0 1
profile picture
.MASSHOLE.
Posts: 7408 - Karma: 11,039
Sobrietycombination of vlookups and hlookups. I just got frustrated after several hours and said fuck it. Remember, I need someone to also be able to implement into the code a 'nearest higher value setting' when completing the second part of the search, when it goes down a column of increasing values. Thats a part that I still haven't found an answer for either.


Ah. I've never had to do something like that second part. Hmm. Good luck.
Jul 17 2014 10:07PM
0 0
profile picture
2_fadez
Posts: 7780 - Karma: 4,183
AT-ATI work in excel all the time. However, i do not know how to do any of the "coding" like aspects of it. Sorry man


I don't know what to call it exactly since I've never done it, but it should take some line of functions or maybe even another approach that I'm not familiar with.
Jul 17 2014 10:11PM
0 0
profile picture
SlurmsMckenzie
Posts: 128 - Karma: -31
SobrietySo I've gotten stuck on something for work in Excel and I'm looking for someone to help me out with it. I figure someone on here knows coding Excel well enough to figure it out, and I'll throw some bills from Paypal to whoever gets it done.
It should be like one line of long code that searches a line for a certain number, then searches down that column for the nearest highest number to a previously calculated one in that original matched number's column, and then when it finds that nearest number, it goes all the way back across that row to report back the first column's number.
Its hard to explain in short, but it should take lookups, index, or match functions. I've also been suggested using a PivotTable, but I know nothing about it and don't have any more patience to learn it.


I'll send more details on what I need exactly done when I send the file, if anyone actually thinks they can actually do it. Bonus if you get it done tomorrow by 5pm.

Help me out NS brahhhhssss. And have some Kate Upton



post sum thong pics bro
Jul 17 2014 10:14PM
1 2
profile picture
KravtZ
Posts: 6637 - Karma: 2,629
I use excel all the time at work. Not exactly sure what you are looking for. But what I would try is to make a pivot table and then do v/ h lookups to find the values that you need? Pivot tables are insanely easy to make

Highlight areas you want to make into a table

Top right click create table
then click creat pivot table

At that point you can see / compare whatever data you want against anything else in the table.


Another thing I would try if I was you would be to set up an index function within a v lookup or h lookup.

I do a lot of financial modeling at work in excel so im pretty good. PM me if you need more help or have some questions
Jul 18 2014 10:33AM
0 0
profile picture
Sno.
Posts: 12155 - Karma: 6,152
Link your Excel table to an access database and just use SQL to query.
Jul 18 2014 4:29PM
0 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
are you familiar with the LARGE function? LARGE(A1:F1,1) = MAX(A1:F1) LARGE(A1:F1,2) will return the 2nd largest number.

if you're unable to formulate something in a single line, you could always make it a multi-line series of calculations hidden somewhere else in the file.

i work heavily in excel on a daily basis, and am sure i could come up with a solution if you could give me a little more of an example of what you're working with.
Jul 18 2014 6:06PM
0 0
profile picture
Greg_o
Posts: 316 - Karma: 82
Barefootin_Fiendi work heavily in excel on a daily basis, and am sure i could come up with a solution if you could give me a little more of an example of what you're working with.


Agreed, if you can show an example or two of: your data, what you want to see happen to it, and the results it would help.
Jul 18 2014 11:55PM
0 0
All times are Eastern (-4)