Ms_excel@yahoogroups.com a few rules (revised/condensed 03 July 2007) ===================================== PLEASE READ THIS, You agree to this as part of your...
38063
rtkachuck
Jan 3, 2011 1:08 pm
I am using Excel to design fabric patterns. It is easy to set up a grid and insert colors into a particular cell. What I am wondering is, using the find and...
38064
David Lanman
who1012000
Jan 3, 2011 6:14 pm
Hello, I did this in the recorder, but it is not clear to me how it worked. I looked for Yellow and found it. It also replaced with Green. I do not see how to...
38065
David Smart
smartware_co...
Jan 3, 2011 8:26 pm
In Excel 2003 it's in the Find/Replace (ctrl-h) pop-up. Just click on Options to show it. Regards, Dave S ... From: "rtkachuck" <candr1@...> To:...
38066
Kenil Gala
kenil14
Jan 3, 2011 9:57 pm
Hi group, i want to draw a graph for skewness and kertosis for some random numbers, but i am unable to it. could anyone help me out with problem?.i am little...
38067
Dr John C Bullas
johnbullas
Jan 4, 2011 9:40 am
The two properties are calculated using skew() and kurt() how you would plot these on a graph I don't know unless a standard distribution from the data can be...
38068
L allen
loaa3406
Jan 4, 2011 2:53 pm
It's been a while since I've had to deal with skew & Kurtosis but those are a measurement of distribution. If you want to plot the numbers to show ...
38069
Kenil Gala
kenil14
Jan 4, 2011 4:30 pm
Hi Dr John, Thanks for your reply, even i calculated by the formula and i got some values. but i could use this and interpret it only if i am able to plot it...
38070
Kenil Gala
kenil14
Jan 4, 2011 4:31 pm
Hi allen, you are correct about the information you gave, i know to calculate, just needed to plot a graph in excel by distributing it normally. Its not a part...
38071
Bryan
indy_bryan
Jan 4, 2011 6:46 pm
Hello, We have a spreadsheet that has several tabs. Somewhere among those tabs there are a couple of embedded links to other spreadsheets (on a different ...
38072
loleeolee
Jan 4, 2011 7:00 pm
Hello All - this is my first time posting and I'm looking for a formula that works 100% of the time. I use Excel 2007 and need to match data from sheet 1 to...
38073
Darren Eves
darren_eves954
Jan 4, 2011 7:41 pm
Not being an expert on statistics, but having been studying for my own benefit, its my understanding that Kutosis and Skew are measures. I dont think you can...
38074
Spear, Ted (US - MGTTS)
ted_spear
Jan 4, 2011 7:58 pm
Is all you want to do is to break the link? If so, just go to Edit Links and click on Break. Ted Spear From: ms_excel@yahoogroups.com...
38075
Bryan
indy_bryan
Jan 4, 2011 8:51 pm
We need to fix the link - breaking it causes issues with formulas. B From: ms_excel@yahoogroups.com [mailto:ms_excel@yahoogroups.com] On Behalf Of Spear, Ted...
38076
Spear, Ted (US - MGTTS)
ted_spear
Jan 4, 2011 9:02 pm
Try searching your sheets for ! which is in a link. Ted Spear Senior Cost Analyst Meggitt Training Systems (t) +1 678-288-1387 (e) ted.spear@......
38077
David Smart
smartware_co...
Jan 4, 2011 9:14 pm
You use the word "accurate"; in your subject line, but "streamlined" in your request. Re "streamlined". Area checks like this are a bit cumbersome because of...
38078
Bryan
indy_bryan
Jan 4, 2011 11:53 pm
Will that also find links in conditional formatting? From: ms_excel@yahoogroups.com [mailto:ms_excel@yahoogroups.com] On Behalf Of Spear, Ted (US - MGTTS) ...
38079
Spear, Ted (US - MGTTS)
ted_spear
Jan 5, 2011 1:13 pm
I just tried to embed a link in a conditional format and it would not let me. Are you sure you have a link in a conditional format? Ted Spear From:...
38080
Bryan
indy_bryan
Jan 5, 2011 1:32 pm
Pretty sure - things were copy and pasted from other workbooks. B From: ms_excel@yahoogroups.com [mailto:ms_excel@yahoogroups.com] On Behalf Of Spear, Ted (US...
38081
Spear, Ted (US - MGTTS)
ted_spear
Jan 5, 2011 1:41 pm
Can someone else take a shot at this? Maybe there is some way to put a link in a conditional format, I can't do it. B, What happened when you searched for an...
38082
Mark Bacheldor
m_bacheldor
Jan 5, 2011 2:14 pm
I have run across an issue before with links to files located on hard drives. The only way that I could change this was to go into the Microsoft Script ...
38083
Roland
rolandlopez24
Jan 5, 2011 2:51 pm
I have a complex model that I can't understand why I can't find data that I know exists. Vlookups are about 1/3 of the model and when I search for data -...
38084
Randy Harmelink
rharmelink
Jan 5, 2011 3:11 pm
The most common gotcha I run into in that scenario is trailing blanks... ... [Non-text portions of this message have been removed]...
38085
Spear, Ted (US - MGTTS)
ted_spear
Jan 5, 2011 3:15 pm
Did you run Text to Columns on your Source and Array data? Did you sort your Array data by the Criteria field? Are you sure there are no leading or Ending...
38086
Roland
rolandlopez24
Jan 5, 2011 3:24 pm
I did run text to columns on source dan array data. I do not have trailing blanks - leading or ending spaces.......
38087
Spear, Ted (US - MGTTS)
ted_spear
Jan 5, 2011 3:26 pm
Is your array data sorted by the Criteria field? Ted Spear From: ms_excel@yahoogroups.com [mailto:ms_excel@yahoogroups.com] On Behalf Of Roland Sent:...
38088
Roland Lopez
rolandlopez24
Jan 5, 2011 3:33 pm
Not sure what you mean? Sorted by criteria field... From: ms_excel@yahoogroups.com [mailto:ms_excel@yahoogroups.com] On Behalf Of Spear, Ted (US - MGTTS) ...
38089
Spear, Ted (US - MGTTS)
ted_spear
Jan 5, 2011 5:18 pm
Your Array Table, the one you’re pulling your data from, has to be sorted by the field that your looking to match, ie; VLOOKUP(a1,Sheet1! B1:B1000,false)...
38090
Bryan
indy_bryan
Jan 5, 2011 5:43 pm
Search for the ! is in a lot of cells - pulling data from other sheets in the workbook. Having to go thru then one by one looking for the link From:...
38091
Roland Lopez
rolandlopez24
Jan 5, 2011 5:55 pm
That info is sorted. Not sure if we are different pages, but I am looking for data that exists in the model that contains the VLOOKUP. I pull the data fine,...
