Excel Work

[2_fadez]

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

 

[.FRY.]

I'm here for the Kate Upton. that is all.

 

[.MASSHOLE.]

You tried v-lookups?

 

[2_fadez]

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.

 

[AT-AT]

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

 

[.MASSHOLE.]

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.

Ah. I've never had to do something like that second part. Hmm. Good luck.

 

[2_fadez]

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

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.

 

[SlurmsMckenzie]

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

post sum thong pics bro

 

[KravtZ]

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

 

[Sno.]

Link your Excel table to an access database and just use SQL to query.

 

[Barefootin_Fiend]

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.

 

[Greg_o]

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.

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.