Hi there,
I've got varoius worksheets with entries driven from a front page.
Depending on what is typed on the front page determines whether a
particular sheet has data entered or not. I'd like to summarise only
software 發表在 痞客邦 留言(0) 人氣(0)
Help! My boss told me to convert all these spreadsheets listing dollar
amounts to Euro.
I can't figure out how to do it.
software 發表在 痞客邦 留言(0) 人氣(0)
I have an Excel workbook, some stock symbols have smart tags, some don't.
Have checked to make sure stock symbols are capped, smart tags option is on,
checked the work book, closed amp; opened the file ...WTR is one that doesn't
show up. It's traded on the NYSE.
software 發表在 痞客邦 留言(0) 人氣(1)
Can anyone offer a way to convert a column of postcodes/zipcodes (currently
in general format) to text. Reason is to import these into a Word document
as part of a mail merge. Currently when imported they show up with a
decimal point and a zero after the number (eg. 4173.0) Manually changing
the column to text format doesn't appear to effect the merge. Only thing
software 發表在 痞客邦 留言(0) 人氣(0)
I have read through alot of problems here in the forum but none have answered
mine.
I am wanting to compare 2 columns for exact matching (ex. quot;Green32quot;). And
if there are two matching items I want to be able to say quot;A matchquot; in a
software 發表在 痞客邦 留言(0) 人氣(0)
hello community
In the Excel feature, can anybody please enlighten me on how to use the -
Validation gt; Validation Criteria gt; Custom
software 發表在 痞客邦 留言(0) 人氣(0)
TAKE A LOOK AT THE FOLLOWING DATA. Is there a way to create a macro or a one
button solution to create the following subtotal line. Currently this is a
manual process, and I know we can do it via the sigma function, however I'm
looking for a quicker/automated solution. One that creates quot;Subtotal
Descriptionquot; and Subtotals the gross profit and gives me the % profit.
software 發表在 痞客邦 留言(0) 人氣(1)
I use Win XP Home Edition, SP2, Excel 2003
Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed
lt;formatgt;lt;cellsgt;lt;numbergt;lt;custumgt;
software 發表在 痞客邦 留言(0) 人氣(0)
Can anyone tell me how to plot a relative frequency histogram (using
midpoints). I know how to to make a histogram using the analysis tools, but
can't get Excel to put in plots for midpoints....
software 發表在 痞客邦 留言(0) 人氣(10)
I want to create a drop down box that displays a rebar size. upon selection
of the size, in the output cell designated, I would like it to display the
area of that rebar size. I can't use a simple if statement because there are
10 different size and you can only use 7 nested if statement. what can I do?
If your drop down is A1
software 發表在 痞客邦 留言(0) 人氣(1)