Looking for a possibility of making this formula shorter, any ideas? Thanks
This formula is producing this
The active cell is A6...
Ok Gang, I have a project with a crazy time crunch and was hoping to have some help on the below.
I have a query of data that has a column with my Lookup Value (Variation 1) and a secondary column with an offsetting value that is backwards (Variation 2).
If you look at the data in column...
Here is the logic behind the formula I am searching for.
I have a cell where I enter values A1, say 1 through 10.
I have a master list of numbers 1 through 10, just for reference in the formula. Say B1:B10.
Lets say I enter the number 7 in A1.
I want another cell to then search a...
I have two column where I need to perform a match function or formula.
If the first 4 or more characters in both "A" and "B" column matches, I want to see the results in the third column.
MONTEFIORE MEDICAL CENTER-MARGARET KEALY...
Hi, this is my formula;
i have rows of this formula which i want to put into a table (using excel for mac) but after highlighting and clicking a table template the results all change to...
I'm combining the index and match formula in excel to extract data given a specific reference. The problem however, is that my formula only finds the first listed piece of data rather than all the data that matches the reference.
I want to find ALL the projects that "Joe" is...
I need to pull data from one sheet and put it into another automatically.
My home sheet has the following data...
Column A: % of project completed
Column B: Status of project (either in progress, on hold, or completed)
Column C: Task Description
Column D: Date project was started
Hello, I have been searching for a solution to this with no luck so will explain my problems here:
I have three worksheets relating to three football teams. On each of these worksheets, B2:B19 contains the names of the players and C2:C19 contains the number of goals that each player has...
I have a column containing a large-ish number of cells (column "A"). Each cell contains a concatenation of a dollar figure (can be pos or neg) & a card number & a datetime (MM/DD/YY hh:ss). Example:
I have generally been...
I want to write a macro that match multiple column and return a value as I show in the table below</SPAN>
Hey all, I am trying to get this formula to work properly. I want it to be able to grab the data for the selection of the date that was made. For instance, if I want to show only dates of the driver jake for Jan, then it will only return those dates for that month. Right now, the formula I have...
I came up with this formula to find matches in another file which I cannot edit:
=MATCH("*"&A2&"*",'[F4 2006_ECO Log.xls]ECO Log'!$D:$D,0)
It works fine, except I want to find the last match in column D (there are something like 3 total matches). Match seems to return only the first match. I...
I have a spreadsheet containing 3 columns, First Name, Nickname and Last Name.
In a separate column, I concatenate First Name and Last Name as =PROPER(D2&" "&F2) to return the following:
It appears that there are many spaces between between First Name and Last Name even...
I need to return a match to worksheet1 if the names exist in either worksheet 2 or worksheet 3. The formula I normally use is...
Column D5:D9999 contains either of 5 values: ABC, MNO, XYZ, #N/A, null
Column E5:E9999 contains either of 4 values: WORKING, NOT WORKING, #N/A, null.
In F5:F9999, I want value of Z1 if column D MATCHES EXACTLY as X1 AND column E MATCHES EXACTLY as Y1 else AB1.
Z1=Good, X1=ABC, Y1=WORKING...
I tried to find similar problem and solutions by searching the older posts in forums but I didn’t find anything so I apologize if this is a repeated question but I would really appreciate any answer and help.</SPAN></SPAN>
1) I have a data set updated every week –...
I have been pulling my hair trying to figure out a formula that would work. Here's my issue: I have a database that keeps track of all material purchase for any specific day. Each material type is assigned a code. I have another worksheet that keeps track of the "selling" price of...
I have a list of Representatives that report to a specific Supervisor who then reports to a specific Manager. (see ex: below)
<TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=240><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset...
need a formula for the below example
i need a formula to extract data table as below to match the string in a cell
a2: dec hex
a3 49 31 (result from...
I really need some help here, and I was hoping that someone might be able to answer my formula question please (I've been trying to figure this out for 4 hours, and I know one of you experts will have it solved in 2 minutes :))
Ok, so I have a spreadsheet with this layout (see below)...