Under Look In options Find allows for search by formulae OR values OR comments Replace is restricted to formulaes ONLY WHY? cp Have a look at this google search result. This topic came up a couple days ago and was addressed by Dave and Myrna. http://snipurl.com/cd9j Gord Dibben Excel MVP On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <cp@discussions.microsoft.com> wrote: >Under Look In options >Find allows for search by formulae OR values OR comments >Replace is restricted to formulaes ONLY >WHY? ...

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" <anonymous@discussions.microsoft.com> wrote in message news:110F5183-D1CE-4C5A-A7F8-90D01E500FBE@micr...

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 $25. How can I effectively limit the pick of only two records from the set with 10 dups? ...

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...

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...

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. Abhijeet wrote: > 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...

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 $1:$A$20". 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'...

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 MakeLink_file MakeLink_datNum 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? Fred D16 = 4383 D17 = 1267 F16 = \\FDR-server\General Pool\Beatrix\DATA SHEETS\FDR_PDF\4383 DAT 01.pdf F17 = \\FDR-server\General Pool\Beatrix\DA...

Hi, 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? Thanks -- 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...

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! Regards Try 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! > Regards -- Dave Peterson Hi Dave, tried that already...no joy. Dennis Ah, I think I've found it. Somehow my formulae (which have wor...

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 ACTUAL RECORDS 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 ...

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...

Hello, Need some help with combing cell values. I know that =value(a1&b1) example. Cell A1 = 1 Cell B1= 3 Output =13 But if A1 has a text value such as ABC, I get an error on output. With text and numeric, how do you combine? Thanks JR try leaving out value -- Don Guillett SalesAid Software donaldb@281.com "JR" <gaspower@nothing.sbcglobal.net> wrote in message news:mqWJb.5923$KV4.1988@newssvr29.news.prodigy.com... > Hello, > > Need some help with combing cell values. I know that =value(a1&b1) example. > > Cell A1 = 1 > Cell B1= 3 > > Ou...

I have any array which read a csv file and I am using split and populate these fields into my table.. temp= 5245,test1,23.45 temp1=3456,test1,23.45 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 Hi, Test to see if they are numeric first. If IsNumeric(sampleid) Then TESTID = CInt(sampleid) Else ...

Hi! 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). Thanx! M 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...

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 formula. 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 Tur...@discussions.microsoft.com> wrote: > In Access database I want to compare the values in two fields in a form a= nd > then select the higher value, insert it into another field and then use i= n a > formula. > > E.g. Value 1 =3D 500 =A0 Value 2 =3D 60...

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 input. =('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 thanks anyone Excel recognized the dates, and put a time scale axis on the chart. This means each day from first to last is represented, even if that day has ...

Found it here by chance, excellent tool! http://www.codeplex.com/CRMDocumentation Follow the instructions there. Excellent tool to extract CRM JavaScript, picklist values, Attributes to generate documentation or, in my case, test cases based on customizations. HTH, Mohamed ...

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 YTD). The fields I have to work with are Name, Cost Center, and Cost Center Type. 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...

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<...

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...

I have a cell value with something like this: 5830 Paradise Bay - wall or 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. Any ideas? Thanks, Diane 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...

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: 4,5,3 I want the result of the fuction (say in a2) to display the result of 12 Any help greatly appreciated. Regards Mike 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: > >4,5,3 > >I want the result of the fuction (sa...

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 -- balcovj ----------------------------------------------------------------------- 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 -- HTH RP (remove nothere from the email address if m...

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 manually-created values. ...