Excel Functions

Extracting max value from 3 columns of data in exel

My warehouse system contains length, width, and height calculations but the longest side isn't always in the correct column (length). Does anyone know how to extract the max, median, and miminum measurement across 3 columns of data?

Excel custom format, weekday & date line break query....

I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be...

Problems using VLOOKUP

I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

Excel 2002 Copy GetPivotDATA function

I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell

Reconcile two sets of data without a unique field.

I have two data sets that have account number and dollars. There are duplicate account numbers and dollars as this is a batch of credits interfacing with another system. I need to reconcile the first set to the second set. So in think it is something like this, if account number and dollar in...

Microsoft Excel - I need to find rows that match a user entered entries and sum results of column b

I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem,...

Image storage in Microsoft Excel

I'd like to know the code or procedure to use in Ms Excel that will help me to lookup a photo into a cell. I've observed some customised banking software which is able to display the picture and signature of a client whenever his unique account number is entered. Could I use excel to perform the...

Import text from another excel workbook

I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?

i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute to what to get my...

MAXIF formula

Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF funciton. Can such a function be added into Excel? Any suggestions for sources?

Help finding duplicate info in Excel in different columns

Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a...

Excel Function Help

I am designing a spreadsheet to keep track of various data. I have a list of birthdays (month and day in separate columns) and I would like to pull the person's name that corresponds to the particular month. I have attempted to us the lookup function for this, but if there is more than one person...

Excel Form Macro

Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...

Automatic Publish web page when excel data changes

I have 4 files created from scheduled jobs on the AS400. Each file automatically updates a worksheet in an excel spreadsheet. (sheet1 to sheet 4) On the 5th worksheet I have graphs based on the 4 sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the...

Excel 2007 - allocating non-repeatable values in a set

I am creating a questionnaire. There is a set of 4 words and users are asked to rate each word with a value from 1 to 4. The user can not repeat any of the values between the 4 words in one set. There are many sets of 4 words and as a result, this process has to be repeated many times. I am...

Writing excel RTD to a file

I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming...

Search for duplicates in a collumn and delete the row on which it occurs

Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather...

Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)

I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the...

Excel question

Is there a way to rename the cell in Excel? For example...Cell A...Change the name from Cell A to Apple....