Member of the Month

theabortionator
April, 2025

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

11 years ago
7 3
profile picture
.FRY.
Posts: 5686 - Karma: 22,819
I'm here for the Kate Upton. that is all.
11 years ago
5 0
profile picture
.MASSHOLE.
Posts: 7578 - Karma: 12,722
You tried v-lookups?
11 years ago
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.
11 years ago
0 0
profile picture
AT-AT
Posts: 3281 - Karma: 3,258
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
11 years ago
0 1
profile picture
.MASSHOLE.
Posts: 7578 - Karma: 12,722
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.
11 years ago
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.
11 years ago
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
11 years ago
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
11 years ago
0 0
profile picture
Sno.
Posts: 12311 - Karma: 7,884
Link your Excel table to an access database and just use SQL to query.
11 years ago
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.
11 years ago
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.
11 years ago
0 0
All times are Eastern (-4); Currently it's 0:47AM