-
Have a table of data and I need to interpolate a value. The row names are A,B,C,D and the column names have 0.5, 0.6, 0.7, 0.8 etc. If I want to look up in that table under row B for a column value 0.67, how would I accomplish that? Any ideas!?? Thanks!
-
Hi I have a problem with calculating an average of top 10% of a data set. I know about conditional fromating, so basicly I need a formula which would do similar thing. I figure out how to calculate average of top ten values, but percents would do better. So, I calculate top ten values using combination...
-
Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
-
I am not an expert at Excel (casual use for a few years making simple reports) but I've taken on a task of creating a spreadsheet showing the game schedule for teams in our club. This spreadsheet is a tab in a workbook that keeps track of scores and stats. I'll describe the best I can. We have...
-
To simplyfie bentleybob's suggestion you can have a look at this add-in: http://www.mrexcel.com/chal/pareto.zip All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values. It also make it possible...
-
Hello everyone, I've always found Excel to be the most flexible and easiest program to use. I'm trying to build a spreadsheet, and I need it do several specific functions. I've done a lot of experimenting, but have not got it all. I'm hoping someone here can assist me, or at the very...
-
Ok I have a file with 2 sheets basically. Sheet 1 is basically a database of agents with their addresses, tel, details... With this database I created a table so I can move around easily. In Sheet 2 I created a standard contract for these agents. So I basically need to create 1 contract per agents and...
-
OS: Windows XP; MS Excel 2007 I need to update the "price" for a corresponding "Code". The updated Price is in a spreadsheet among as many as 15,000 "Codes" in a column and the corresponding "Price" is in another column in the same row. I need about 400 items updated...
-
I'm hoping you can help me with a formula. I have a workbook that has 3 tabs. The first is the main log, the second I want to extract certain information on a line that's tied to 2 criteria (product name and tract number) and the third I want to have extract based on 3 criteria (product name...
-
I'm doing analysis on a large data set, it's of the form below, however there are sufficent coloums to mean it has to split over several worksheets, and transposing the data would not help... this asside for now we'll assume only one worksheet p1 p1 p2 p2 p2 p3 a 3.59 2.55 3.07 1.17 3.84...