Returning Cell Reference
Dec 10, 2007
I have a sheet containing collums with month an weeks. I try to find out which collum the first week start and where te last week the same mont ends.
Let say A5:E5 is filled with december in each cell. The row below (A6:E6) says week 48, week 49, week 50, week 51, week 52.
I want a formula telling me de Cell reference where desember begins en where it ends. In my Excample (A5 and E5). If Possible, I also could prefer that the cell reference was to rows below start/end. In my example (A7 and E7)
View 14 Replies
ADVERTISEMENT
Feb 17, 2006
I am wondering if there is a way to return a cell reference by having excel
look at a table with certain parameters. For instance...
If there were a table with repeated dates such as:
Feb 12 1500 1530
Feb 12 1745 1750
Feb 13 1215 1245
Feb 13 1610 1700
Feb 13 1850 1900
Feb 14 1050 1140
Is there a way to return the cell number (ie A6) for the first instance of
Feb 14?
View 13 Replies
View Related
Nov 14, 2008
I have a sheet which uses a vlookup to find the data on a large sheet. normally to get the cell reference of the data i would use cell("address",......
However this appears not to work with a vlookup.
View 10 Replies
View Related
Jul 11, 2014
From the following example:
A1 TAG B1 mileage
G10-1622 15246
G10-1622 15246
G10-1583 15246
G10-1622 28659
G10-1195 28659
G10-1622 28659
desired results
Enter tag in cell
G10-1662
Mileage
15246
15246
28659
28659
I would like to enter a particular TAG # in I5 and return all the mutiple associated data
See attached : tire2.0.xls
View 9 Replies
View Related
Oct 29, 2013
In Sheet2 I have a list of cell addresses showing values such as D5, D32, D59, D221, D869 stored in cells AB7:AB16. In Sheet1 the "D" column holds dates. I want to return the corresponding date for each D# cell into Sheet2 in column AC7:AC16. I'm unaware of the proper syntax for this. I though it would look something like:
='Sheet1'!('Sheet2'!(AB7))
however that doesn't work.
View 2 Replies
View Related
Jan 8, 2012
How do I change a formula cell reference based on another cell's reference? I'm building a schedule that looks to a task's trigger and adds days based on that relationship. All entries in column "A" will be text and all cells in "B" will be the simple formula "=A2" or "=A3". Due date is calculated by adding the value in "C" to the preceding date in column "D". In the spreadsheet below, the trigger for "Budget set" is "Specs written" with 3 days added to the previous due date.
________A________________B_____________C_________D
1 Task___________Trigger_____________Days_____Due Date
2 Design begins__Proj OK______________10____10-Jan
3 Specs written__Design begins (A2)____5____15-Jan (D2+C3)
4 Budget set_____Specs written (A3)____3____18-Jan (D3+C4)
If the trigger for A4, "Budget set", changed from A3 to A2, is there a way that the formula that determines the due date in D4 could read the trigger cell reference in B4 so that the value in the corresponding row in column "C" is added in the date column?
View 4 Replies
View Related
Mar 11, 2009
I have a table that displays data from another worksheet. This is what the cell reference behind the table look like:
View 2 Replies
View Related
Feb 15, 2010
I have lets say 12 months of data. I have formulas that reference the latest 6 months. When I insert a new column to input a new month, how can I make the formulas include the new months without manually updating them.
EXAMPLE:
12 months of data exist in cells B3:M3 going from B3(oldest) to M3(newest). Formulas reference latest 6 months of data in cells H3:M3. When a new month hits, I insert a column after column M.I would like the formulas to now reference cells I3:N3 which is now the newest 6 months.
View 14 Replies
View Related
Jul 20, 2014
I have a workbook with 1000+ worksheets, all of which have 3-letter names. On a master sheet, I would like to make a query of how many non-empty cells there are on a subsidiary worksheet. This works:
Code:
=COUNTA(ABC!A:A)
What I'd like to do from time to time is input in column A a varying set of 3-letter worksheet names, say
AAB
ABC
CDE
And have a formula in column B that converts this to
=COUNTA(AAB!A:A)
=COUNTA(ABC!A:A)
=COUNTA(CDE!A:A)
I've learned that simply substituting the cell references A1, A2, A3 for AAB, ABC and CDE doesn't work. What do I need to do to achieve this?
View 2 Replies
View Related
Apr 25, 2014
Let's say I've ended up with the number 8 in Cell D4 for example. Is there a formula that can return the letter "G" (The 8th Column) so I can use it in future cell references ? If so, let's say we store that in Cell B5. How do I now refer to a cell in a chosen Row of that same Column by reference to Cell B5 ? For example if I want to refer to Cell G33 can you refer to this Cell in some form like Cell(Contents of Cell B5;33) ??? Don't want to use R1C1 type references if possible.
View 9 Replies
View Related
Mar 29, 2008
i have this formula in cell e28 =IF(B28<>"",LOOKUP(B28,STOCK!A1:A500,STOCK!B1:B500),"") and when its empty it returns a blank cell
but in cell e29 i have exactly the same formula =IF(B29<>"",LOOKUP(B29,STOCK!A1:A500,STOCK!B1:B500),"") but i returns #n/a
why is this and how do i stop it i want the cell to be empty unless there is a code entered in b29 in which case it will look up the relevant info for me
View 9 Replies
View Related
Apr 23, 2014
Basically, I want to use look in one cell to get a value then in a table look in a coloum to find the same value then return a value from a different column in that row.
This is to organize groups of children participating in an event.
See the attached spreadsheet for details.
Groups example.xls
View 1 Replies
View Related
Feb 5, 2009
I am looking to return the larger value of 2 cells into a seperate cell.
View 2 Replies
View Related
Jul 30, 2009
I had this problem a few days ago and NVBC suggested Text to Columns, which worked initally but didn't seem to 'save' or stick... also, I'm not sure what is causing the problem to begin with. It was my understanding that Excel couldn't return a truely 'blank' value. If a cell was blank or empty, Excel still 'sees' it as Zero. WHY then, for the Love of Gummi Bears, will Excel not calculate my formula. It's a simple formula!
=A13+B13
I've tried
=SUM(A13+B13)
I've tried
=IF(ISERROR(A13+B13),"",A13+B13)
But if don't TYPE in a 0 or a number, then it just does nothing. 50 + 0 = should be 50 not blank or #VALUE!. 50 + Nothing = should be 50 not blank or #VALUE!
Attached is a small copy of what I'm trying to do. I've double checked that all number cells are formatted to numbers, not text. I tried the Data:Text to Columns trick. I've tried Tools:Options:Show Zeros. I've tried Manual and Automatic Calculation. They shouldn't have to type in 60 cells of Zero to get the simple calculation.
View 2 Replies
View Related
Jan 7, 2013
I'm linking one sheet in a workbook to another. The formula is simple,
='Link 1'!E1
If there is data in the cell, it replicates it which is what I'm after. However if there is no data in the cell it returns a "0", not what I want at all.
View 2 Replies
View Related
Nov 11, 2013
I am trying to return a cell with a simple yes or no answer and having a little difficulty.
I have entered the following formula which is returning #NAME
=IF(E4<=1.25,ORH4<=0.01,yes)
Calculation needs to be as follows:
Install Cost <1.25 and Profit atleast 0.01
The YES NO needs to be in the Invite? column
View 4 Replies
View Related
May 28, 2009
I have a current formula using SUM formulas obviously in the answer cell the answer is returning 0 due to no data inputed, how do i make the cell show empty.
eg. =SUM(A1*A3) returns answer 0 need cell to be blank.
View 2 Replies
View Related
Jun 27, 2009
i'm trying to figure out a way that would return the address of the cell that contains the highest/lowest value of a range i.e. =cell("address",min(g3:g6)).
if the lowest value was in cell g4, i'd want the output from above formula to be $g$4.
View 14 Replies
View Related
Jun 24, 2013
view the graph below:
A
B
1
EXTENSION 101
2
INBOUND TALK TIME
55M19S
3
OUTBOUND TALK TIME
1H22M13S
[code].....
I am trying to create a formula that will act like a vlookup but will return a different row. In other words, On page two I need to write a formula that says: In column 1 if you see "Extension 101" return column 2 of the row right beneath it, so on and so forth. So page two should return a mirror of what page one says, the difference is I would like people to type in "Extension 101" in a cell and it would return all the date.
A
B
1
EXTENSION 101
2
INBOUND TALK TIME
55M19S
[code].....
Cell A1 would be typed in//Cell A2-A4 would be static//Cell B2-B4 would return these numbers based on info from A1.
Cell A1 would always be unique in column A (on both pages).
View 4 Replies
View Related
Mar 4, 2009
The conversion rate is updated daily from telephony reports, and I manually sort it into conversion order each day before sending it round.
What I want to do is find the highest converter for each team.
So:
Column A ('TeamLeader' range) has the Team leaders in, column B has the agent name ('Agent' range), and column F has the agents conversion rate ('conversion' range).
I think I'm on the right track with this formula:
=(MAX(IF(TeamLeader="Bonnie",Conversion))
But this only displays the figure in the Conversion rate, how to I get it to 'step back' 4 column's and show the agents name?
I tried this:
=VLOOKUP(MAX(IF(TeamLeader="Bonnie",Conversion)),A5:F60,-4,FALSE)
but that returns #NA - is this because I'm asking the VLOOKUP to look 'backwards' 4 columns?
View 9 Replies
View Related
Feb 5, 2010
I have find this code on web and I'm good with VBA at all. So I need help with this code below.
instead of text( marked with red ) i need to return value from cell, let's say from A1 and I want to have this macro running when excel is opened.
Sub Animate_String()
Dim stxt As String
Dim x As Integer, y As Integer
Dim Start, delay
stxt = "Lookup cell Aq"
For y = 1 To 100
View 9 Replies
View Related
Apr 1, 2008
my spreadsheet to return the word unit if cell a18=1 or the word units if its over 1 but i also want the cell to remain empty if there is nothing input into cell a18 is this possible
View 14 Replies
View Related
Feb 25, 2014
Essentially what I'm trying to accomplish is import a file from Quickbooks and determine whether it was a Credit Card, Check or Invoice based on the account number.
For example:
45-12345 should return the value CC in an adjacent cell because it contains the "-" character.
I0123456 should return the value INV in an adjacent cell because it contains the "I" character.
01234567 should return the value ACH in an adjacent cell because it doesn't contain either character.
I tried using VLookup, but I can't figure out how to write a formula for when it just contains a character, only if it matches it or is text/number.
View 4 Replies
View Related
Apr 19, 2013
All the answers I can find for this address either the auto-calculation setting or formatting the cell as a number. I am using this same formula in a bunch of cells to calculate totals: =SUM(E12:E17). It works find all over the sheet, except in one box. There is no difference in formatting or data type or anything.
Not working: notworkingexcel.png
Working: workexcel.png
The numbers being summed from the cells above the one in question are referenced from another sheet if that is relevant.
View 3 Replies
View Related
Feb 27, 2009
I am not sure if this is doable in VB or if there is an excel function to do this but I am using a rather large worksheet that is shared amongst my staff. I would like to have the sheet clear any filters that have been used by one member and for the sheet to save with the cursor in the home cell (A1). This way the sheet is ready for the next user. Can this be done with VB?
View 8 Replies
View Related
Oct 4, 2011
I am using the following code (I found here), to test for unlocked cells when I am creating a sheet. (I'm really new at this) I have 2 issues. First this (below) doesn't end itself, I have to escape or pick another cell. Second, I would like another button to return cells to the previous color after I have corrected any locked/unlocked cell errors.
Private Sub CommandButton2_Click()
Sheets("bf calcs").Select
Sheets("bf calcs").Unprotect ""
[Code]...
View 6 Replies
View Related
Jul 10, 2012
I am trying to return the value in the cell immediately to the left of a Maximum value found in 3 cells. I've added the MAX(Q4,S4,U4) formula into AF4. I've tried several variations without success.
View 5 Replies
View Related
Mar 25, 2013
Seems like this one should be pretty easy but I'm stuck... I just want to return a boolean based on whether the currently active cell contains the character "#". I've been trying to use the find method but I can't figure out how to convert a match or lack of a match to a boolean.
View 1 Replies
View Related
Feb 2, 2014
i am trying to return the numerical characters from a cell so in A1 i have 6-4 3-6 7-5
A2 i would like to return 6
A3 4
A4 3
A5 6
A6 7
A7 5
there are also possibilties that A6 & A7 could b 2 digit numbers such as 10-12 or could be 9-11 or 11-9 etc
View 4 Replies
View Related
Mar 3, 2010
I would like to have the answer to a formula, say in cell G6, to show up in say G5. I notice in my college coarses, doing our homework through excel, the solutions are always in a cell around the entry cell.
View 9 Replies
View Related
