Can I move comment indicator to another corner of cell?
In Excel 2002, those little triangular comment indicators display in
the upper right corner of their cell.
I want them in the U.L. corner instead. Can I tell Excel to do that?
(There is no such option in Tools / Options / View's Comments panel.)
Thanks.
*** Tag: Is there a way to copy a cell value into a cell comment? Tag: 138870
Protection from cut and paste
Cell C1 is protected and has the formula A1 + B1. The users in my office
sometimes cut and paste A1 and B1 to A2 and A2. After the cut and paste the
formula in C1 changes to A2 + B2. What I want is for the formula to remain
A1 + B1. Is there a way to protect or prevent cuts and pastes? Tag: Is there a way to copy a cell value into a cell comment? Tag: 138867
send mail recipient gray (inactive)
Hi
I am working with excel 2007 and I added "send mail recipienton" on Quick
access toolbar. and now it is gray(inactive) and I can't select it. I am
using Outlook 2003. I tried this kb but it didn't work for me. My registry
keys same.
http://support.microsoft.com/kb/918792
What can I do for this problem
Thanks... Tag: Is there a way to copy a cell value into a cell comment? Tag: 138860
Largest non-blank sequence in row or column
I'm trying to create a formula which will count the largest number of
sequentially non-blank cells in a column or row.
e.g. if the row had the following columns:
|y|y|y|y| | |y|y|y|y|y|y| |y|y|y|y|y|
the value would be 6 because it is the largest number of "y" values
next to each other. Any Ideas please let me know.
I'm using the formula to work out the longest number of days I do a
particular task in a row. I update the spreadsheet daily and put a "y"
in the row if I do that task. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138859
Heading styles in a TOC
I have created some new Heading Styles for use in a document.
How would I get them to be recognized in a TOC?
Are there specified Styles that ONLY will work or is there a setting to get
them to be recognized?
Dave French Tag: Is there a way to copy a cell value into a cell comment? Tag: 138856
Is this possible please
Is this possible or am I asking too much of excel?
If I have 254 working days in the year from D4 to D257 can it be done by a
formula to work out the percentage automatically when a person is absent?
It needs to know how many working days has passed in the year. Obviously up
to today's date I believe it's 51 days. So, it would tell me for example
that someone who has been off 10 days would have been off 5.1%. As each day
passes the percentage would go down, or up if more time was taken off. It
would finally tell me at the end of the year just how much time has been
lost at a glance.
If anyone has any ideas I would be most grateful.
Bryan. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138855
Excel 2002 parameter query returns some blanks instead of data
Hello and thanks up front... (I'm going bonkers),
It's invoice time, so in my "Job Records" file, I'm using a parameter query
(Excel 02, Microsoft Query) to return only those records that occur in one
specified month.
In the original Excel "Job Records" file on which the query is based, one
column of data, labeled "PO", lists purchase order names (e.g. "VBL" for a
verbal Purchase Order) or numbers (e.g. "102509"). The column is
automatically formatted by Excel as "General", and I just let it ride.
A second column of data, labeled "Funding Entity" lists codes - some codes
are letters , others are numbers, (e.g. "GF" for Gen. Fund, "21" for 21st
Fund) all formatted as "Text".
When I execute the query, everything works great (the correct records,
selected by month, are returned) except that the cells containing numbers
formatted as "General", when returned in the "PO" column, are skipped so the
resulting cell is just blank. And in the resulting "Funding Entity" column,
cells containing letters (e.g. "GF") end up blank and all those containing
numbers formatted as test, e.g. "21", show up just fine.
So, I end up with a "PO" column containing all the entries that were "VBL",
but only blanks where the entries that are numbers (formatted as "General")
should be and a "Funding Entity" column containing only "21", but no "GF"s.
I tried (feebly) to change the numbers formatting to "Numbers", but it
didn't work.
Anyone know where I went wrong? Tag: Is there a way to copy a cell value into a cell comment? Tag: 138854
Get Column Header from Match in a Array?
Here's what I am trying to do.
I have a table of date, with the column names in Row 1, Column B-J.
The Data from B2:J11 is dates. On a second sheet, I have the dates
listed chronologically, I'd like to use a formula to take at the date
in the second sheet, and look at the array on the first sheet and tell
me what column it is in - or give me the text value from row 1 in that
column. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138852
=?Utf-8?Q?Loosing_formula_when_changing_ro?=
Iâ??m stymied and could use some help.
I have a file that contains data in Sheet1 A1:A3 with values a,b,c. In
Sheet2 B1:B3 I reference Sheet1â??s data with =Sheet1!A1 and so on. In Sheet2
if I try change the row reference from A1 to A2 I donâ??t get the value, I get
the formula displayed =Sheet1!A2. The problem is that I have 2 columns like
this and one works with reference changes the other doesnâ??t.
I have checked cell formatting and option settings in all cells and they are
all identical. The only clue Iâ??ve seen is that before the attempted change I
can still do a precedent trace but after changing the row # to a valid row
the trace indicates that the cell doesnâ??t â??contain a formula with a valid
referenceâ??. The formula/link is getting clobbered, but I can find no
settings that would effect that and would appreciate any hints. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138848
Automatically add calendar events?
Using the powershell, is there a way to add calendar events to specific
mailboxes? Our vacation time request system is a home grown web-based
application. We'd like to configure it so that once the vacation time has
been approved, the requesters Outlook calendar would then automatically be
populated with "out of office" entries for the days off they requested.
Thanks in advance! Tag: Is there a way to copy a cell value into a cell comment? Tag: 138847
Unexpained Shortcut to Personal.xls
I have Office 2003's Excel set up on my desktop and my laptop under XP Home.
They both work as expected.
Personal.xls is in Program Files\Microsoft Office\OFFICE11\XLSTART on both
machines. However, on the Desktop alone there is a shortcut to it in
Documents and Settings\Main\Application Data\Microsoft\Excel\XLSTART. I
delete the latter and open Excel and all the macros in Personal.xls that are
tied to buttons and menu items work just fine without the shortcut. But
when I close Excel, the shortcut reappears in Documents and
Settings\Main\Application Data\Microsoft\Excel\XLSTART. This does not happen
on the laptop.
There must be something in the way I have the two Excels set up. The laptop
has my name as the user name and the desktop has Main as the user name.
This is the only difference I am aware of.
This does not cause any problems that I can see but I am curious about why
it should happen on one machine and not the other.
I will appreciate any guidance on this riddle.
Thank you. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138837
Please help: opening a datastream comma delimited
Hello
Anyone help? I'm trying to open a data stream in excel from my own remote
server which uses comma delimitation and I'm trying to get Excel to open as
such, instead of sticking all the data in one column.
Someone suggested the code below might work from but on 'startrow' it throws
up a 'compile error' that 'named argument is not found'.
Anyone have an idea how to do it? I'm no expert.
Workbooks.Open
Filename:="http://x.x.x.x:8085/ppui/resultscsv?CUSTOMER=BOOKINGID=8165806",
Origin:=437, Startrow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False,
Semicolon:=False, Comma:=True, Space:=False, Other:=False,
FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True Tag: Is there a way to copy a cell value into a cell comment? Tag: 138828
Adding like occurences
I can't figure this one out and need help. Sheet1 has names in col 1 and
values in col 2 -
I want to add totals together for everytime a certain name is found in col 1
in the sheet 2. (Name is listed multiple times on sheet 1)
This is easy but I can't remember how to do it!
Thanks for any help provided.
Annette Tag: Is there a way to copy a cell value into a cell comment? Tag: 138823
Recipies of South INDIA
Do you want to know to how to make mouthwatering,spicy foods?
If you want to know how to make delicious South Indian foods please
visit
http://recipesoftamilnadu.blogspot.com/ Tag: Is there a way to copy a cell value into a cell comment? Tag: 138820
time line in chart
Hi
How do I put a vertical line in a chart in excel at a given point? i.e.
timeline
Thanks
Jon Tag: Is there a way to copy a cell value into a cell comment? Tag: 138817
Pick several numbers from a list to get as near as possible to required total
I have a list of several hundred policies each with a different value.
Occasionally I have a request to 'sell off' policies to a certain value. At
the moment I manually select policies from the list till I get 'close
enough' to the total. Is there a way of automating this and getting the
closest result possible?
To put numbers to my problem above, suppose I have the following 9 policies
1 $11,234.67
2 $604.50
3 $7,632.00
4 $5,638.76
5 $16,345.98
6 $23,678.43
7 $15,678.44
8 $1,007.17
9 $53,713.97
I get a request to sell of $54,500 worth, at a glance I would probably
select policies 8 & 9 (totaling $54,721.14), where as infact policies 3, 4,
5, 6 & 8 would be a better choice as they total $54,302.54
All help would be much appreciated
Gerry Tag: Is there a way to copy a cell value into a cell comment? Tag: 138815
Excel 2007 - Conditional Formatting copy/paste errors
I find that if I create a conditional format at one cell and then copy that
to a multitude of others, the variable references within the conditional
format will not adjust accordingly. For example:
At cell A1, I have the conditional format of "=IF(A1>0,1,0)". If I copy
this to cell B2:B3 (in one stroke), I will find both cell B2 and B3 to have
the same formula "=IF(B2>0,1,0)". This of course is fine for cell B2, but
it is not fine for cell B3. I would expect cell B3 to reference itself; not
cell B2.
Another problem is that if the receiving cells should have a conditional
format previously in place, the copy from A1 to B2:B3 will append to the
preexisting conditional format as opposed to overwriting them. The only
circumvention I have for this bug is to clear any possible conditional
format before I paste to the receiving cells, B2:B3.
So, how do I resolve this apparent bug in Excel?
btw, this bug is not present in Excel 2003.
Thanks,
Bob. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138813
match and index function - getting it to keep its original reference
I am using the match and index function to pull in data from a
separate worksheet. I am using Column A as the reference cell,
whereas my formula lies in Column F.
The formula pulls in the data fine. The problem is, when I sort the
data set, the match index function maintains the original reference
cell and does NOT refer to the same row.
So, for example, if my formula references A3, the formula continues to
use A3 after I sort the cell (as if I had used an absolute
reference).
Does anyone know how to fix this? How can I pull in data using
matchindex (or vlookup), but also be able to sort the rows without
messing the formula up? Is there a way to use a list or named ranges
to accomplish this?
The actual formula I am using (in case it helps) is:
=IF(ISNA(INDEX(CMS2!I:I,MATCH('CPT Summary for CMS Comp'!A27,CMS2!
A:A,FALSE))),0,INDEX(CMS2!I:I,MATCH('CPT Summary for CMS Comp'!
A27,CMS2!A:A,FALSE)))
Thanks for any suggestions. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138810
Show leading zeros (eg: 000123)
When I import a file that originally had numbers such as "000123" in
excel, the number only shows 123. Is there a way for me to get the
cell to show 000123?
Thanks Tag: Is there a way to copy a cell value into a cell comment? Tag: 138809
adding a leading 00 to some loan numbers
I've got several thousand loan numbers which need to be updated to a
ten-digit format by adding a leading 00.
That's easy enough to do, HOWEVER, some of them have already been updated
with the leading 00.
What formula can I use to add 00 only to those which have not already been
updated?
Thanks.
--
alan Tag: Is there a way to copy a cell value into a cell comment? Tag: 138799
Counta not calculating correctly???
Count anyone shed some light on this issue.
I am using the statement
n = WorksheetFunction.CountA(Cells(i, 13), Cells(i, 17), Cells(i, 22))
I am trying to get a value for how many of the 3 cells have data in them.
While watching my n count I am seeing it reading 2 when there is clearly
only data in one of the cells.
Any idea why this would be reading incorrectly?
Thanks for any help
--
KWB Tag: Is there a way to copy a cell value into a cell comment? Tag: 138779
e-mail addresses
Hi Everyone
I am having a problem with e-mail address in excel spreadhseet.
Some of them go in, in black the same as the rest of the spreadsheet, but
others show up in BLUE and then they are clickable. I would just like them
all in black.
What should I do, or what an I doing wrong?
Thanks
Donna Tag: Is there a way to copy a cell value into a cell comment? Tag: 138771
how to create an excel template
I am having problems trying to create an excel template.
I took a xlt file. and put it in the dir
C:\Program Files\Microsoft Office\Templates\1033
However I do not see it ever showing up in the
file>new>on my computer
is there something special you have to do?
thanks Tag: Is there a way to copy a cell value into a cell comment? Tag: 138761
How to add SAMPLE ONLY overlay?
Hi - how do I add 'SAMPLE ONLY' diagonally across a tab and have it somewhat
transparent?
I've tried pasting in a jpg of SAMPLE created using Viso, but that
background of the pic is not tranparent.
Pete Tag: Is there a way to copy a cell value into a cell comment? Tag: 138758
Selecting a folder to save xml to...
I have the following code that works fine in Excel 2003 and I am
looking for something similar that will produce the same result but
for Excel 2000
can anyone help?
If xmlfolder = "" Then
MsgBox "Select folder for the XML file", vbCritical
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "SELECT FOLDER"
.AllowMultiSelect = False
' Folder selected
If .Show = -1 Then
xmlfolder = .SelectedItems.Item(1) & "\"
End If
Regards
Jamie Tag: Is there a way to copy a cell value into a cell comment? Tag: 138755
Autofilter - No. of Rows
Does anyone know of any way to increase the number of rows displayed in
Autofilter, becauase when working on large ranges it doesn't display all
values.
Any help greatly appreciated..... Tag: Is there a way to copy a cell value into a cell comment? Tag: 138754
Startup
Hello
My Excel VBA is sometimes used by other people, and they ara "abusing" my
codes by using toolbar commands. I want to make Excel VBA and to hide /
disable all toolbars and any other Excel command. I want that only my
buttons can be used.
Beforehand thanking for any help,7
Sb. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138753
flip columns to rows
Is there any way to 'flip' a worksheet with one command, so that columns become
rows (or rows become columns)? Tag: Is there a way to copy a cell value into a cell comment? Tag: 138748
Outsourcing Data Entry 100% guaranteed or your money back
Data Entry Outsourcing Services ensures high quality, result oriented
in time. We promise to deliver excellent output at low turn around
times and cost-effective rates. Our dedicated team of highly
experienced professionals to provide you high quality outsourcing
services. Do visit us at http://www.dataentryoutsourcing.co.uk/dataentry_services.php,
to know more about our Data Entry Outsourcing Services and avail our
services at affordable rates.
Data Entry Outsourcing provides data entry services like numeric data
entry, textual data entry, image data entry, data format, data
conversion and also online data entry, offline data entry with 99.98%
accuracy and time bound.
Data Entry Services also provides form data entry, data capture, HTML/
SGML coding, image scanning, file conversion with low cost, high
quality, time bound and high data security.
By taking advantage of Data Entry Outsourcings domain knowledge,
quality processes, high-tech infrastructure, and global delivery
options, clients are able to perform better while allowing them to
concentrate on their core competencies. Based in U.K., Data Entry
Outsourcing operates from offshore multiple production centers in
India. Contact us for more information about Data Entry Services.
E-mail Us: info@dataentryoutsourcing.co.uk
Phone (India): +91-794-000 3000
Fax : +91-794-000 3002. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138745
Remove Final Character from Cell.
Hi All,
I am trying to remove the final character from a cell with a find and replace.
the cell contents are like the following example.
07APR07A
needing to be 07APR07
But other cells in the list are already in the format of
07-Apr-07
07APR07*
I have managed to remove the * by using the tide ~ character. So I don't
know if there is a similar character to remove the last character only.
But am stuck with the last character. Can someone please help. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138741
runtime error '429' activex component can't create object
We recently moved to "visual studio 2008" . Our addin workd find on our
development machine which has Excel 2003 and Excel 2007. When we create the
installation package and install onto a machine with only Excel 2003 we get
the "runtime error '429' activex component can't create object". Any ideas
please.
Thanks in advance Tag: Is there a way to copy a cell value into a cell comment? Tag: 138738
Excel crashed with ntdll.dll when opening a file
Dears,
My Excel crashed with ntdll.dll when opening a file
Error signature
AppName: excel.exe AppVer: 10.0.6834.0 ModName: ntdll.dll
ModVer: 5.1.2600.2180 Offset: 00010f29
I am using Office XP with SP3, Windows XP with SP2.
Thanks
B. G. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138736
Putting a "period" at the end of every cell's-worth of text
Hi. I have a large number of cells in a column, each of which
contains text. Some cells of text end in a period, some do not. Is
it possible to write a function that would add a period to the end
of each textbox? I am not worried about corner cases, i.e., where
the text ends with "M.D." or suchlike.
Thanks for any help - Tag: Is there a way to copy a cell value into a cell comment? Tag: 138727
Time passed sinec date in column A
I am trying to greate a document that will tell me when someone needs
to renew thier training. I have 1, 2, 3, & 4 yearly training programs.
I want to have a system where I can set conditional formating to goy
amber when it has been 10 months since the date and then Red when over
a year>
I have a date on column A. In column B I want to know how many months
have passed since that date.
I am sure the solution is easy, but I can't work it out!!
Many thanks
Steve Tag: Is there a way to copy a cell value into a cell comment? Tag: 138726
I am interested in knowing some of your favorite Excel Add-ins
Hello - I have been too cheap to buy any excel add-ins or plug-ins,
and then recently I downloaded one (i.e., the PUP v6 toolbar), and
realized that it was worth much more than the $40 price tag.
I would be interested to hear some of your favorite add-ins (either
free or purchased) and why you find them to be valuable. It would also
be helpful to have the link to where they can be found.
Thanks!
- M Tag: Is there a way to copy a cell value into a cell comment? Tag: 138725
Data grouping and averaging in excel 2003
I am looking into purchasing a data logger that will collect voltage,
amperage with a time scale.
Below is a sample of the data and a summary to be generated above the
data. I have some problems with how I can have a msexcel spreadsheet
automatically calculate averages and total times for each zone.
I would like a summary for many separate zones with a dozen or so
sessions that have recording to last from 10 to 100 seconds within
each session and automatically disregard calculating any values in
column C that are <30 & all rows in column B that have been
disregarded in column C.
Averaging for volts and amps will include all readings within each
zone.
To calculate time, I would like to calculate the difference between
when the amps go above 30 & the time when the amps drop below 30 + the
time one row down.
Formulas
In A2 =(A11-A9)+(A15-A13)+(A20-A15)
In B2 =AVERAGE(B9:B10,B13:B15,B18:B19)
In C2 =AVERAGE(C9:C10,C13:C15,C18:C19)
In A3 =(A24-A22)+(A29-A26)
In B3 =AVERAGE(B22:B23,B26:B28)
In C3 =AVERAGE(C22:C23,C26:C28)
A B C D
1 total time avg volts avg amps total zone
2 00:00:54 25.3 122 b
3 00:00:30 25.0 125 f
4
5
6
7
8 time volts amps zone
9 13:30:12 24.9 131 b
10 13:30:18 25.3 124 b
11 13:30:24 39.4 12 b
12 13:30:30 38.4 9 b
13 13:30:36 26.3 130 b
14 13:30:42 24.9 114 b
15 13:30:48 25.3 125 b
16 13:30:54 39.4 2 b
17 13:31:00 38.4 8 b
18 13:31:06 25.2 111 b
19 13:31:12 25.1 117 b
20 13:31:18 39.4 3 b
21 13:31:24 38.4 13 b
22 13:31:30 25.1 125 f
23 13:31:36 25 131 f
24 13:31:42 38.4 7 f
25 13:31:48 37.6 11 f
26 13:31:54 25 124 f
27 13:32:00 24.9 130 f
28 13:32:06 24.8 114 f
29 13:32:12 37.6 11 f
Can anyone help me with this? And an I on the right track?
Can this be accomplished without VBA? (as I have no success with it in
the past)
Thank you for your consideration. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138705
Data grouping and averaging questions in excel 2003
I am looking into purchasing a data logger that will collect
voltage, amperage with a time scale.Below is a sample of the data and
a summary to be generated above the data.
I have some problems with how I can have a msexcel spreadsheet
automatically calculate averages and total times for each zone. I
would like a summary for many separate zones with a dozen or so
sessions that have recording to last from 10 to 100 seconds within
each session.
I would like to automatically disregard calculating any values in
column C that are <30 & all rows in column B that have been
disregarded in column C. Averaging for volts and amps will include all
readings within each zone.
To calculate time, I would like to calculate the difference between
when the amps go above 30 & the time when the amps drop below 30 + the
time one row down.
Formulas
In A2 =(A11-A9)+(A15-A13)+(A20-A15)
In B2 =AVERAGE(B9:B10,B13:B15,B18:B19)
In C2 =AVERAGE(C9:C10,C13:C15,C18:C19)
In A3 =(A24-A22)+(A29-A26)
In B3 =AVERAGE(B22:B23,B26:B28)
In C3 =AVERAGE(C22:C23,C26:C28)
A B C D
1 total time avg volts avg amps total zone
2 00:00:54 25.3 122 b
3 00:00:30 25.0 125 f
4
5
6
7
8 time volts amps zone
9 13:30:12 24.9 131 b
10 13:30:18 25.3 124 b
11 13:30:24 39.4 12 b
12 13:30:30 38.4 9 b
13 13:30:36 26.3 130 b
14 13:30:42 24.9 114 b
15 13:30:48 25.3 125 b
16 13:30:54 39.4 2 b
17 13:31:00 38.4 8 b
18 13:31:06 25.2 111 b
19 13:31:12 25.1 117 b
20 13:31:18 39.4 3 b
21 13:31:24 38.4 13 b
22 13:31:30 25.1 125 f
23 13:31:36 25 131 f
24 13:31:42 38.4 7 f
25 13:31:48 37.6 11 f
26 13:31:54 25 124 f
27 13:32:00 24.9 130 f
28 13:32:06 24.8 114 f
29 13:32:12 37.6 11 f
Can anyone help me with this? And an I on the right track?
Can this be accomplished without VBA? (as I have no success with it in
the past)
Thank you for your consideration. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138703
How to add the date after the "A1"
Hi,
I type "The information gathered as of March 9, 2008" on cell "A1"
Is there a way to make a date default like
"The information gathered as of " & Date (default).
Your help would be much apprecated. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138697
Compatibility Question
I have created a file in Excel 2003, and saved as "Excel 97-Excel2003
&5.0/95 Workbook" and I am running XP.
The file utilizes several macros, VLOOKUP and COUNTIF commands.
My question is if this file is distributed throughout the general
public, what do you believe could be some unforeseen compatibility
issues I am not aware of as it will obviously be opened on several
versions of Operating Systems and versions of Excel?
Do I have a 50% chance of success that it will be compatible? What
would be your guess at the percentage of success?
What are my options to make it more successful throughout more OS
systems and Excel versions?
Will some type of compatibility pack be the answer?
Thanks for the anticipated help.
JR Tag: Is there a way to copy a cell value into a cell comment? Tag: 138687
RIGHT & UPPER Function help
I am working in Excel 2002. The postal address is in cell A1 with the
postcode. I am looking to take the postcode out of the cell and put in new
cell and turn into CAPITAL letters.
1 The High Street London ln22 4tb
I am struggling with the function for this. I am at =RIGHT(A1,8) which
takes the postcode from the end of the address and enters ino cell A2 but I
thought i may have been able to add the UPPER to the end of the function but
this does not work. I can do this as =UPPER(A2) in cell A3 but was hoping to
undertake the augument in the same cell. Also can I adapt the augument to
include where I only have 6 characters ie LN24tb?
Many thanks
Roger Tag: Is there a way to copy a cell value into a cell comment? Tag: 138685
Excel 2000 opens then immediately closes
Running under Vista Home Premium 64.
When I open a worksheet/workbook it loads, appears on the screen
then immediately closes.
Have carried out 'repair', prefer not to un-instal re-install.
Help! Tag: Is there a way to copy a cell value into a cell comment? Tag: 138684
dividing one time by another
If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where the
times are minutes:seconds) I get weird answers. If I reformat the cells with
[m]:ss, the formula doesn't work at all.
Any suggestions?
Adrian Tag: Is there a way to copy a cell value into a cell comment? Tag: 138680
Open Excel File in a new Window
Hi,
I am not sure if this is an Excel problem or it is in Office in
General. If I open two MS Word Files, they open in two separate
windows. However if I open two Excel files - they open in the same
Window.
The benefit of having two separate windows is that they can be placed
side-by-side esp. if you have multiple monitors.
Is this possible in Excel?? I hope my description is clear. If not
let me know and I would try to explain again.
Regards,
O.O. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138664
Match & Index function - Cell format problem that is keeping it from
Hello - I am trying to use the Match and index functions together.
Typically, I have been able to match and pull in the data without a
problem.
But now that I am using a text file that I export into excel, I am
running into problems. Basically, the formula won't work (even though
I have tried trimming the data, changing all columns to text, general,
and number.
The only way that the formula works is when I copy and paste the
actual reference cell into the reference array from the range that I
am seeking to pull in the data.
So for example, my formula reads: =INDEX(Sheet2!B:B,MATCH(Sheet1!
A419,Sheet2!A:A,FALSE)),
but the only way that I get the data from Sheet2 column B is by
physically pasting Sheet1!A419 into column A in in Sheet 2. Then and
only then will the values from Column B in sheet2 appear in Sheet 1--
as the formula is intended to do.
Is anyone familiar with this problem? Does the function typically
work better when the sheets are formatted as general, versus number,
versus text?
Thanks for any suggestions.
(Also, another problem I am experiencing with the files----and it may
be related-----is that the formulas will not work altogether. That is,
any formula that I punch into the cell does not produce a value, but
instead the cell shows the formula when I press enter. However, this I
am usually able to fix by formatting the book as general and then
retyping the formula in the cells). Tag: Is there a way to copy a cell value into a cell comment? Tag: 138657
Formula
Can anyone help please with this formula.
=COUNTIF(B208:AE208,"H")
This works fine to count the number of H's in a row. What I need is to also
count HD as .5 in the same row and add it to the final total.
For instance in the first row H H HD H = 3.5. I may at a later
date also need to add to it again with a S also to count 1.
Can anyone help with the formula please. Maybe COUNTIF isn't the correct one
to use.
Thanks.
Bryan. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138653
Something New
Excel 2003 SP2.
I've been revising a workbook and came across an Excel quirk that's
new to me. I haven't read about anything similar in the newsgroups.
The workbook in question usually has all worksheets protected and the
workbook protected, but I've unprotected the workbook and all
worksheets and unhidden all but one worksheet. Some of the worksheets
have embedded spaces in their names. There are no worksheet events,
but there are workbook Open, Activate, Deactivate and BeforeClose
events. There's also one udf, named HasFormula, that takes a Range
object as its argument and returns TRUE/FALSE if the first cell in
that range has a formula. I only use this udf in conditional
formatting formulas.
I'm editing formulas in one of the worksheets that's usually hidden.
Call it Sheet C. The formulas were something like
='Sheet B'!X99
and I want to change them to
=IF('Sheet B'!X99<>"",'Sheet B'!X99,'Sheet A'!C123)
I edit the formula in a cell in Sheet C, inserting the 'IF(' at the
beginning, copying the original cell reference in the formula bar,
appending '<>"",', pasting the cell reference, and appending a comma.
Then I press [F2] to change to Enter mode, repeatedly press [Ctrl]+
[PgUp] to move to 'Sheet A', move to cell C123 in that worksheet (now
in Point mode), type a right parenthesis and then press [Enter].
Here's the quirk: Excel tries to enter the edited formula into 'Sheet
A'!C123 rather than into the cell in Sheet C that I began editing.
Fortunately, 'Sheet A'!C123 has a validation rule that rejects the
formula. I should also mention that Sheet A has separate frozen panes,
and C123 is in the lower, unfrozen pane.
Has anyone else had Excel do this? I can work around it, so I'm not
looking for an immediate fix, but this is definitely annoying. If
there's an easy fix, I'd be grateful for any pointers. Tag: Is there a way to copy a cell value into a cell comment? Tag: 138648
returning more columns with vlookup?
Hi all
by default vlookup returns 1 column. Is there a way to return more than
1 (not necessarily adjacent) columns?
example
instead of
=VLOOKUP(38, A2:L10, 3, FALSE)
using something like
=VLOOKUP(38, A2:L10, (3,7,9), FALSE)
that would return cells in columns 3, 7 and 9 ?
Thanks! Tag: Is there a way to copy a cell value into a cell comment? Tag: 138627
Is there a way to copy a cell value into a cell comment?