How do I match using partial or approximate values?
Fri, 5 Sep 2008 10:25:01 -0700
I want to compare/match data from two 1,000+ row spreadsheets where the
values are similar but not exactly alike. For example, on one spreadsheet I
have a name like John P. Smith Associates, and on the other spreadsheet I
have John Smith Assoc. I would like to find and return a match using a
partial value, ...
|
Creating new worksheets using data from a single sheet
Fri, 5 Sep 2008 10:03:00 -0700
I have a worksheet that has 50 rows of data on it and I wanted to create
seperate sheets for each row of data. Is there an easy way to do this or do
I have to create 50 seperate sheets and copy the data over?
Please help, this could take me days.
Ryan
...
|
Totaling cells in multiple worksheets
Fri, 5 Sep 2008 09:58:00 -0700
I am looking to total up the same cell from multiple worksheets within a
workbook.
For instance, if I have 10 worksheets (one being the summation worksheet),
and a particular cell in 3 of those workbooks are populated with any type of
value, I want the summation worksheet to show 3. For clarity, I do ...
|
multiple validations
Fri, 5 Sep 2008 09:47:02 -0700
I have an excel file that has validation set up to choose numbers from a
list. In the column next to the numbers, I have a description of what the
numbers represent. Is there anyway to be view both columns in my drop down
list, but only insert the numbers? I thought maybe I could just merge the
two column ...
|
Calculating the distance customers live from a branch office
Fri, 5 Sep 2008 09:25:52 -0700 (PDT)
I work for a bank in the Chicago area. We have a number of branch
offices and are interested in determining how far our customers live
from their bank branch.
My data is displayed in Excel similar to below:
BRANCH LATITUDE LONGITUDE CUSTOMER LATITUDE
LONGITUDE DISTANCE (IN MILES)
Main Offic ...
|
Add "/" to a date string
Fri, 5 Sep 2008 09:24:01 -0700
I have dates of birth entered into a column as 41384 which I would like to
insert the "/" symbol so that the dates read 4/13/84. The month never
includes a leading zero (4 for April not 04), however the day of month always
does. ...
|
Substitutions
Fri, 5 Sep 2008 09:19:01 -0700
Column B has Department Names Column C has the department codes, the
department codes are the headings of columns F-H. What formula can I set that
will read the previous column and choose the applicable heading codes in
coulumns F-H. ...
|
|
|
sumif with a second condition
Fri, 5 Sep 2008 09:01:01 -0700
Help please! I'm a beginner here and I have a working sumif function to
which I need to add a second condition. This second condition is to only sum
if the text in column A is a certain 3-letter code. The closest I've gotten
is a #value error that will work if I limit the text condition to just one
cell. ...
|
conditional if statement
Fri, 5 Sep 2008 08:57:03 -0700
I have two sets of data..the first set contains flow rate data for each day
of the month for a year, and the second set of data contains rainfall data
for each day of the month during the same year. In a seperate column I want
to pull the flow data that is associated with days that have recorded
rainfall (we ...
|
Dates and SumProducts
Fri, 5 Sep 2008 08:37:13 -0700
I have ~3000 lines of data. Column D includes an incident date for data
collected over the entire current year. Column E includes an incident type
(there are ~20 varieties). Column F includes the incident status (3 types).
I need to come up with a formula (or multiple) to count the number of times a
spec ...
|
