In an Excel spreadsheet I have 200,000 (two hundred thousand) Ordnance Survey
(UK) grid references in the format AB1234567890 (ie a 10-figure reference). I
need to reduce these to a two-figure reference (ie AB16). Is there a way of
doing this other than manually?
software 發表在 痞客邦 留言(0) 人氣(0)
I created a countif formula, but have a great amount of exact values to put
in a number of cells which will count up another sheet with those values. Is
there an easier way to input the formula for each cell other than editing the
copied formula over and over again? i.e. =COUNTIF(Sheet2!G9:G30007,
quot;=reddog1quot;) I will need to change reddog1 to reddog1, reddog3, bluecat1, etc.on your first sheet set up a list of the terms you want for example in A1 put
software 發表在 痞客邦 留言(0) 人氣(2)
Hi,
I'm trying to sort through a very large amount of data, and to get averages
from it. (14800 ows in the full version !!). What I need to do is
1) Find out how many times each DELAY (column B1) appears for each AIRLINE
software 發表在 痞客邦 留言(0) 人氣(0)
I have a chart in MS Excel 2000 and when I select it, copy it, and then paste
it into InDesign CS2, the labels on the lower horizontal axis do not come
along. Is there some special way to do this that I'm missing?
1. Are you pasting into a frame? If so the default setting is to crop
software 發表在 痞客邦 留言(0) 人氣(0)
Is it true that their is a particular font best for auto fitting column width
and row height in Excel 2003? If so what is it?
software 發表在 痞客邦 留言(0) 人氣(1)
How many quot;IFquot; statement can I nest in Excel?
Thank you.
Kopel--
software 發表在 痞客邦 留言(0) 人氣(0)
Can anyone help? I can't think of a way to do this in a single cell
expression.
I have a column of week ending dates next to weekly sales next to end
of week stock holding and I need to add a column that shows how mnay
software 發表在 痞客邦 留言(0) 人氣(1)
I am creating a database/spreadsheet for my website (nolimitsports.net) and
when I try to publish the sheet to the web my 90 degree rotated text is no
longer rotated? Can anyone help me out with this.
software 發表在 痞客邦 留言(0) 人氣(0)
I am measuring a selection of cast metal parts. What formula do I use to
determine whether the dimension is highrer than the upper limit or lower than
the lower limit.
The high limit is .7129quot;, the low limit is .5943quot;
software 發表在 痞客邦 留言(0) 人氣(4)
Hello,
I am exporting a report from crystal reports into Excel 2003 and I keep
getting an error message that Excel has quot;Renamed invalid sheet namequot;. It is
pulling up a Microsoft office Excel File Repair Log.
software 發表在 痞客邦 留言(0) 人氣(10)