Testing a range of cells in an IF FUNCTION
Trying to test a range of cells in an IF Function. I would like the function to look at 15 cells in a single row, find a value within those cells, and then return another value if TRUE/FALSE. As of now, I can only apply the "logical test" in the IF formula for ONE CELL ONLY. I would like it to test a RANGE of cells in one row, find if any of the values match my logical test, and then return a value. Anyone understand or know how to do this? I tried apply "lookup" function, but I don't think it will work
aaronplange at hotmail.com
maybe someth...Word merged with Access
I am using both Word and Access 2003.
When I merge a Word Letter with Access, sometimes not all of the queries
show up, in the drop down box, to link the letter with. Does anyone have any
ideas of why this happens? Is there a way to make all of the queries show
up? Are the queries limited to a certain number? I would appreciate any
help or ideas that you can give me.
Without more information, I can only guess...
Any chance any of those queries that are not showing up are NOT "select"
queries (i.e., they are Make Table, or Delete or Insert queri...assign cell content as file name
I am attempting to create a macro that will save a workbook with the
file name under which I save the workbook coming from the contents of
one of the cells in the workbook. Suppose that each time the workbook
was altered, a specific cell (A1 on Sheet1 for instance) contained the
desired file name for that workbook. It is my goal to create a macro
that automatically assigns said workbook a name based on the content of
that cell. Any help would be most appreciated.
dim myFileName as string
myfilename = "C:\temp\" & thisworkbook.worksheets("sheet1"...Query to Mail Merge issue
I am running Access2003 on WinXP SP2.
I send out dues letters for members of a retiree group. When I try to do a
mail merge to my Dues Query all goes fine except the telephone number in the
query which is (555)555-1234 comes out 5555551234. If I copy the query into
an excel spreadsheet and use that as the datasource for the mail merge it
Is there something I need to do to format the query so it merges with the
In the query format the field to include the parentheses and dash. In query
design view, instead of the field name put an expression alo...Mail merge from Excel #2
I am trying to use the 2nd worksheet of an Excel spreadsheet for a mail merge, but the mail merge helper only allows me to select the 1st worksheet. I don't want to change the worksheet order because I have another mail merge running from the 1st sheet. Is there a way of selecting the 2nd sheet
Thanks in advance
Jo, see the like below about using Microsoft Excel Worksheet via Converter
to do it. You could also copy the page to a new workbook and use it as your
temporary data source. I have run into problems with using some date in
excel when I try to merge with word and have overc...spell check does not visually cycle through cells when run from macro?
I'm trying to recreate the same behavior in a macro that spellcheck has when
the spellcheck button is pressed. The spellcheck does not cycle through the
cells visually when run from a macro, so when there is a misspelled word,
you cannot see the cell it is a part of.
If anyone knows how I can get this behavior to work, it would be GREATLY
I did a record new macro, and got code similar to the following:
Add the fiollowing to your code as shown:
...Formatting cells from internet
I have copied and pasted a chart from a website. (The website will not let me import) The cells are showing numbered values, but when i go to put the formula in it is giving me a zero like it cannot read the numbers in the cell. That is on 3 seperate columns. On the very last column it is reading the numbers
I cannot make it recognize that those columns are numbers to be used in formulas
Thanks for your help!
Use Dave McRitchie's Trimall macro to clean up the data. Then copy an empty
cell, select all your data and do Edit / PasteSpecial / Add and it will coerce
all data back to nu...displyaing the referenced cells ?
Hi everyone !
Working on an excel file full of references, it would be very useful
to be able to make the display to jump directly to the cells
referenced by the active cells I currently see.
So if my cell TU789 reference the cell JI890, I don't want to search
for JI 890, but would like excel to automatically show me this cell.
Do you know if it is possible ?
Is there a shortcut for that ?
It would be difficult to do that generically, as the cell could
contain a formula that references several other cells - which one
should be chosen in this case?
You might think about using ...How do you lock rows for scrolling ?
I'm new to Excel and using Excel 2002. I can do basic functions and basic
sorting, but that's about it at this point.
I've seen some Excel spreadsheet that lock a few rows. Then when you scroll
up only the rows below the locked rows actually scroll.
For example if you have names in row 4 and all the details for each of those
names in rows 5-200, how can you lock row 4 to always stay visible on your
screen, even when scrolling down to view the rows in the 100's?
I hope explained this well enough to get some help...lol.
THANKS in advance !!!
"FISH&q...Hiding Rows with False
I've got a bunch of rows of data that I want to copy and put somewhere
else, but many of the rows have "false" in them. They don't show
anything and just look blank, but they leave the row blank and take up
a lot of space. It looks something like this:
Is there a way to truncate the list by hiding the rows that return a
false value and just making a normal list like the following?
You can apply Autofilter to one of the columns and just select Non-
blanks from the filter pull-down (or, if ...can lookup return cell reference istead of "text" for sumif?
I am trying to use a lookup-function to determine a different sum
range for several criteria.
The problem is that the vlookup returns text and not the cell
reference. Is there a way to get the answer from the lookup expressed
as cell reference instead of text, since sumif can't use text, just
the cell reference?
I use it to calculate the number of hours the staff should be paid, so
it's different from weekdays to saturdays, holidays...Using cell text in a formula
I am trying to use derived cell references in a VLOOKUP formula to matc
data in several tables. For example, A1 contains the cell reference fo
the top left of my array (A3) whilst cell A2 contains the cel
reference for the bottom right of my array (D14). The array I'
checking against starts in column E3.
However, when I use the formula =VLOOKUP(E3,A1:A2,4,FALSE) I get a #N/
error. I need to use the cell references in each VLOOKUP as the arra
sizes may vary in each case. (PS, I've used =INDIRECT(ADDRESS(A1,A2)
to derive the cell references.
Message posted from http://www.Excel...How do I get automatic completion to work for an in-cell dropdown
If I have a list of Alpha, Beta, Gamma and an in-cell dropdown, I'd like
typing 'G' to auto-select Gamma.
I'm pretty sure it was doing that at some point, but now, it does not.
This isn't supported under data|validation.
You could use A,B,G in the dropdown and then use a helper cell with a formula in
Say you put your abbreviations in A1:A3 of sheet2 and the real names in B1:B3,
then you could use:
Joseph Weisblatt wrote:
> If I have a list of Alpha, Beta, Gamma and an in-cell dropd...Highlighting A Cell
Does anyone know how to do a formula that says if a cell equals the wor
FALSE then highlight this particular cell gray?
Typing in Cell A2
IF A1 = FALSE then gray otherwise white
I tried to do it in Conditioning Formatting but can't figure it out t
reference another cell. Any help would be greatly appreciated
Coltsfan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1998
View this thread: http://www.excelforum.com/showthread.php?threadid=46898
Good evening Colt...Make a cell flash
Please help I to make cell b1 flash when it becomes greater than 5
> Please help I to make cell b1 flash when it becomes greater than 5
see response in excel.misc
(replace somewhere in email address with gmail if mailing direct)
"Lloyd" <Lloyd@discussions.microsoft.com> wrote in message
> Please help I to make cell b1 flash when it becomes greater than 5
Thanks for the link. I ...Calculating values for empty cells.
I have a very simple problem that I cannot find the answer to. I have data
in two columns, some of the data in one of the columns is missing and I want
to automatically extrapolate what the data should be based on the trend. How
can I get Excel to fill in empty values without overwriting the known
values. Below is a sample of my data.
Not sure what yo...Extracting Time from a cell that has both the date and the time
I could do with some help here please. I am trying to extract the time
only from a cell that has both the date and the time. Can anyone
suggest a solution?
Thanks in advance. :confused:
Hani Muhtadi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26794
View this thread: http://www.excelforum.com/showthread.php?threadid=466177
If you just wish the time to display, set the cell format to Time.
If you wish to use the time portion then =A1-Int(A1) will give you...Averaging cell's...problems with Div/0
Hi guys. First time poster here so be gentle with me. I am looking fo
some assistance averaging a range of 1 to 3 numbers.
Here is what I have so far.
This works great. What it does is checks to see if there is a value i
the cell, then counts it and divides by the right number. I.E if yo
only have two values out of 3 filled in it divides the number by tw
instead of 3.
My problem... if all 3 fields are 0 then I get a divide by 0 error.
Any suggestion on how to fix this? I don't want my spreadsheet to loo
messy before I start plu...How can I autofill a series to reference non adjacent cells?
I need to create a list of values by referencing a series of non adjacent
cells (they are separated by a set number of rows each but in the same
column). For example the cells should read something like =b2 =b4 =b6
=b8. Of course I could type these in individually but threre are something
like 100 values. Is there a way to auto fill this?
Look at the indirect function for your example
copied down a column will give you a list for non adjacencies.
> I need to create a list of values by referencing a series of...cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more
text is displayed....casn increase the size of the cell, but still only so
much will display....rest of the cell show blank.
+the limit is 1024 characters. You can extend this with manually inserting
linebrekas using aLT+ENTER
> I have cell format to wrap text and it works fine to a p[oint then no
> more text is displayed....casn increase the size of the cell, but
> still only so much will display....rest of the cell show blank.
...access a cell in a range
I have variables:
dim myrange as Range
dim myString as String
myrange specifies a specific column. How can I specify the cell in row
1 of myRange so I can set it's contents to myString?
Hi there keyser soze,
(Fan of the movie, eh? ;) <g> )
Like so ..
myString = myRange(1).Value
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
<keyser_Soze@usa.com> wrote in message
>I have variables:
> dim myrange as Range
> dim myString as String
> myrange specifies a specific ...How do I merge two publisher files?
I am using publisher 2003. I am creating an 80 page catalog. I like to save
page 1-10 as file one, pages 11-20 as file two and so on. When I am finished
with my catalog I need to send one file to the printer. How can I merge all
of my pages together in one file?
Copy and paste. Or if you have Acrobat (not just the free Reader) you can
create a single .pdf file with the parts.
MVP Microsoft [Publisher]
"screnda" <firstname.lastname@example.org> wrote in message
>I am using publisher 200...Moving from cell to cell
Moving from cell to cell using arrow key stopped working. Help!
Maybe hit Scroll Lock key...
If Scroll Lock is on, the arrows still work, but in a different way.
"crys0814" <email@example.com> wrote in message
> Moving from cell to cell using arrow key stopped working. Help!
Hi there cry0814,
It is possible that you have accidentally pressed your scroll lock key which
disables your arrow keys. Try pressing it again and let us know your results
Regard...Two different cells
I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Assuming that Column A contains the first name and Column B the last
....depending on your preference.
Hope this helps!
In article <520FA0CA-1940-42E5-B84D-22BA15D59638@microsoft.com>,
"Hombreck" <Hombreck@discussions.microsoft.com> wrote:
> I have a...imbed excel cell text in a shape
I need to insert a number into a shape that corresponds to a cell in excel.
Kinda like the exploded parts view in a car repair manual.
A callout shape with a text value "123" that is linked to cell A1 in file
It would be nice to be able to auto generate the callouts from the excel file.
shape 123 is cell A1, shape 124 is cell A2 and so on.
what version of visio are you running?
"mystified" <firstname.lastname@example.org> wrote in message
>I need to insert a number into a s...