Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.
Under Look In options
Find allows for search by formulae OR values OR comments
Replace is restricted to formulaes ONLY
Have a look at this google search result. This topic came up a couple days
ago and was addressed by Dave and Myrna.
Gord Dibben Excel MVP
On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <firstname.lastname@example.org> wrote:
>Under Look In options
>Find allows for search by formulae OR values OR comments
>Replace is restricted to formulaes ONLY
...Paste Several Values into one Cell
Hi all. I have data in several cells (I2:GJ2) on one row. I want to copy all of this data into one cell as it appears now (in a particular sequence). Is this possible? Thx in advance.
Not sure if this is what you want but to concatenate data from several cells
into 1 cell, use formula =Concatenate(I2," ",H2," ",G2) just add more cell
references with commas and " " to give a space between each cell value for
all the cells you want.
"sgarrett" <email@example.com> wrote in message
news:110F5183-D1CE-4C5A-A7F8-90D01E500FBE@micr...incremental counter for dup number values
my wife, accountant, is very often bringing home work where she wants to
match offsetting records from two record sets by value only. However, where
one set may have 10 instances of $25, the other may only have 2 instances of
How can I effectively limit the pick of only two records from the set with
...sum values from range of cells if cells correcponding have the sam
hiya, i have a small project and i've spent too much time on this already -
can't figure it out myself. What i need to do is to create a formula which
will find the same values in column A and will sum the corresponding to them
values from columns B:E.
this is a sort of result i want to get:
A B C D E F RESULT:
1 A1 1 5 2 3 A1 31
2 B5 2 6 3 3 A2 19
3 C1 3 7 4 3 B1 22
4 A1 4 8 5 3 B5 37
5 B5 5 9 6 3 C1 33
6 C2 6 1 6 3 C2 16
7 A2 7 2 7 3
8 B1 8 3 8 3
9 C1 9 4 0 3
I would appreciate any ideas how to do this. Thanks and regards,
Assume in G1 down are the unique item...FormView contained in an UpdatePanel always returns NULL values.
I have a formview that is fully contained within an UpdatePanel, and when the
Update command is sent, the textboxes in my formview are always returning
null values. If I read textboxes contained outside of the UpdatePanel, I am
getting the actual values. I have tried getting the values on the
InputParameters of my ObjectDataSource, as well as trying to read the values
directly from the TextBoxes in the FormView, and they both contain NULL
values. I have seen a few other posts from people having this problem, but I
have yet to see a resolution. The code containing the UpdatePa...how do i get mutiple values using vlookup in excel, lookup value .
hi , i have data stored in excel as column a- Purchase order no column b-
Invoice no i want to query basis purchase order no & result should give
mutiple invoice no stored agst one purchase order no how do i do this using
lookup or something !
One way: Invoke AutoFilter.
> hi , i have data stored in excel as column a- Purchase order no column b-
> Invoice no i want to query basis purchase order no & result should give
> mutiple invoice no stored agst one purchase order no how do i do this using
> lookup or something !
I use the following for somet...Variable chart Source Data Y Values
I can't seem to encode the Y-Values of a chart to have a variable
range. (in Excel 2000)
I have tried things like:
="INDIRECT( CONCATENATE( "Sheet1!$A$1:$A$", TEXT($B$1,"0") ) )"
where $B$1 = 20.
I had hoped this would produce (and evaluate) the formula "Sheet1$A
Instead, I receive "That function is not valid".
Does anyone know of a way to do this?
The reason I ask is:
I have a data series which keeps track of monthly values and estimates
the future months' values. This is done using a formula in future
month'...Problems generating an html link based on worksheet values
I want to generate a hyper link based on text in a cell, for example
the cells D16 and D17 generate the text strings in F16 and F17, which
are valid filenames. I have two macros
that should both generate hyperlinks for me (source for these below),
however MakeLink_file does not work, whereas MakeLink_datNum does (I
want to use the more generic MakeLink_file version). Any ideas why
the simpler macro does not work?
D16 = 4383
D17 = 1267
F16 = \\FDR-server\General Pool\Beatrix\DATA SHEETS\FDR_PDF\4383 DAT
F17 = \\FDR-server\General Pool\Beatrix\DA...Getting values to show colors in chart
Excel has numerous charting options. However, I need to display a ma
of a country and let certain parts change color according to value
that are stored in a database.
I can get the values in a normal graph but is it at all possible t
make a custom chart (like a map) where I can get certain parts t
correspond with the values?
Message posted from http://www.ExcelForum.com
I don't believe you can do what you want without programming support. Suppose you create a map of, say the U.S. Now, create a freeform shape that aligns with the boundary of each state. Finally, use a...Values not showing
Stupid question really, but my spreadsheets are just displaying the formulae
in the cells. How do I change them to just display values?
It's so easy I can't see it!
Tools|Options|View tab|Uncheck Formulas
Dennis Saunders wrote:
> Stupid question really, but my spreadsheets are just displaying the formulae
> in the cells. How do I change them to just display values?
> It's so easy I can't see it!
tried that already...no joy.
Ah, I think I've found it. Somehow my formulae (which have wor...Unable to Programically Total Values
I have got a report where the records extend beyond the ranges of the report
period. So if the report period is 3/1 - 3/31, you might have the following
records in the report. Since we are only concerned about time frame that the
records fall within the report, I am manipulating the report to adjust the
Start or End that is DISPLAYED on the report
RecordId Start End
1001 2/25 3/15
1002 3/15 3/31
1003 3/25 4/25
RECORDS AS DISPLAYED
RecordId Start End
1001 3/1 ...Identifying missing numerical values in a series
In column A I have a series of numbers running from 1001 to 9078. These
numbers run in numerical order, but there are known missing values. For
example, the numbers may run 1000, 1001, 1005. In this instance the missing
numbers are 1002, 1003 and 1004. It is these missing numbers that I need to
identify from the column of numbers running from 1001 to 9078. Could these
missing numbers be placed in column C.
Any help would be greatly appreciated.
Try the below array formula. This will be a bit slow...so try with a smaller
range for testing as below..Please note that this is an...Combing Cell Values
Need some help with combing cell values. I know that =value(a1&b1) example.
Cell A1 = 1
Cell B1= 3
But if A1 has a text value such as ABC, I get an error on output. With text
and numeric, how do you combine?
try leaving out value
"JR" <firstname.lastname@example.org> wrote in message
> Need some help with combing cell values. I know that =value(a1&b1)
> Cell A1 = 1
> Cell B1= 3
> Ou...converting text values to number & decimal values..
I have any array which read a csv file and I am using split and populate
these fields into my table..
Now I want to convert my text fields to number and decimels respectively.
I tried the following functions but this works fine if they are number and
fails it was text value.
TESTID = CInt(sampleid) 'CInt(myarray(1))Convert to number
CT_num = CDec(ct_val)
Message posted via http://www.accessmonster.com
Test to see if they are numeric first.
If IsNumeric(sampleid) Then
TESTID = CInt(sampleid)
...Insert spaces between pasted values #2
Is there a way to insert spaces between values that are pasted? For example, i have in rows 1,2,3 values a,b,c and i want to paste them into another list in rows 1,3,5 respectively (with a single-row space between pasted values).
I presume you have more than just 3 rows. A general approach would be
to use a helper column next to your data and to fill a simple sequence
down that column for as much data as you have. Then copy all the
numbers that make up that sequence and paste them immediately below
the sequence in the same column, so that if you have 200 numbers for
example the...access compare values and select higher of two
In Access database I want to compare the values in two fields in a form and
then select the higher value, insert it into another field and then use in a
E.g. Value 1 = 500 Value 2 = 600, 600 to be inserted into another field
and then be multiplied.
On 11 apr, 21:26, Captain Turtle <Captain
> In Access database I want to compare the values in two fields in a form a=
> then select the higher value, insert it into another field and then use i=
> E.g. Value 1 =3D 500 =A0 Value 2 =3D 60...x axis not showing correct values
i have dates on my x axis, but for this graph i am not using all of it, e.g.
it goes from monday to sunday but im only using monday to wednesday and
friday to sunday, but it is showing the whole lot rather than what i have
=('Rel. PE in progress'!$C$2:$CT$2,'Rel. PE in progress'!$DG$2:$DR$2)
i am using this same formula for the values on the graph and they are
showing up correctly. not sure why the difference
Excel recognized the dates, and put a time scale axis on the chart. This means each
Found it here by chance, excellent tool!
Follow the instructions there. Excellent tool to extract CRM
in my case, test cases based on customizations.
...Trying to include all values from 2 tables in Select Query - even where there is no match
I am pulling from a database (that is in very poor shape) trying to
determine weekly hours out of a project accounting system with little
luck. The problem is, I'm pulling each Friday and then have to
subtract YTD Hours from Week 1 out of Week 2 (Current YTD - Previous
The fields I have to work with are Name, Cost Center, and Cost Center
In my query I concatenate these values to create a unique field, so
that I can link the tables together. Where I run into problems, I
have 3 options...Show where they are the same, Show only from table 1,
or show only from table 2.
Often w...issuing numbers to values
i need some help with creating a list of numbers to use as reference numbers
i have 4 columns, the first is the quantity of the item to be made, second is the work order number(the value i want generated), third is the description and the last is the quantity made. i have a list of 200 items and only about 120 or so each week are made each week, but i need to show all items. it starts at where the last number left of and it needs to run consecutivly but not showing numbers in between. i have this formula so far if you can modify it to not show the result in the cel
=IF(A2>0,B2+1,IF(A2<...values 'inside 'base' in a bar chart
I am having problems using the 'inside base' for showing values when I copy a
chart from Excel and put it in Powerpoint. The values look centered in Excel
but when I look at the slide show, the values have shifted to the left of
center. Does anyone have any suggestions? I experimented in versions 2003
and 2007 and it happens in both. Thanks for any help you can give.
Is is a horizontal bar chart? Inside Base means inside the bar at the
end closest to zero, so probably closest to the right. If the labels and
bars are of certain sizes, they might look centered, then after the...splitting cell values
I have a cell value with something like this:
5830 Paradise Bay - wall
Hickory Woods 26 - footing
I need to divide these into two columns separated by the dash. So the
address will go in one column and the other term (wall, footing, etc) will
go into another.
Make sure the column to the right is empty, if not select the column to the
right, right click the header and select insert, now select the column with
the text you want split, do data>text to columns, select delimited, click
next, check other and put in a dash there, click finish
Regar...Adding comma seperated values within a single cell
I need to come up with a custom function that will add up comma seperated
numerals contained within a single cell.
For example if the the cell A1 contains:
I want the result of the fuction (say in a2) to display the result of 12
Any help greatly appreciated.
On Tue, 07 Oct 2008 20:39:01 +1100, Michael Toal <M.Toal@bom.gov.au> wrote:
>I need to come up with a custom function that will add up comma seperated
>numerals contained within a single cell.
>For example if the the cell A1 contains:
>I want the result of the fuction (sa...List of different values in data area
Hi excel specialists,
How Can I automatically get the list of different values from the dat
area and to find out their frequence?
INDIVIDUALLY MEASURED VALUES:
3,5 4 3,5 4 3 3,5 4 4 3
3,5 4 3 3,5 3 3 3,5 4 4
Thanks for your help in advance. Balcovja
balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623
View this thread: http://www.excelforum.com/showthread.php?threadid=39572
Take a look at FREQUENCY in Hep
(remove nothere from the email address if m...Why are the values in my report bound to each other?
I created a report based on a cross-tab query using the wizard. It is handy
in many ways, including keeping the values evenly spaced in each row and
changing their horizontal order in the row by using the left and right arrow
buttons. But can I turn off this feature? I want to insert a
manually-created sub-total of the first 3 values, and it won't let me insert
that manual sub-total between the 3rd and 4th values, because I can't create
a wider space between any of the values.
I don't see any different properties in these values and the