PIXNET Logo登入

software

跳到主文

software

部落格全站分類:數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 7月 20 週四 200620:08
  • Print Filter??


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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do i convert a spreadsheet with dollar amounts to euros?

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do I add smart tags to stock symbols in an Excel chart?

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Convert postcode to text

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Comparing 2 list

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Validation

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • SUBTOTALS

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • how to insert month date year and day of week

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • relative-frequency histogram

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)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do I change the output value of a drop down box?

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)

  • 個人分類:title
▲top
«1...3193319431953197»

個人資訊

software
暱稱:
software
分類:
數位生活
好友:
累積中
地區:

熱門文章

  • (74) Who makes the best pedal mods?
  • (21)why would the space bar not work in excel?
  • (18)aa ab ac....ax ay az....ba bb bc....zx zy zz ?
  • (6)Where is the tick icon in Excel
  • (3)i cannot get favorites in excel 2003
  • (2)=SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5))
  • (2)To show quot;0quot; instead of #N/A
  • (1)need help with macros
  • (2) OK, Sold My 89 Les Paul, What Should I Get?
  • (1) Gibson owned by Guitar Center?

文章分類

  • title (6,014)
  • title (5,999)
  • title (6,022)
  • title (5,957)
  • title (4,957)
  • title (3,013)
  • 未分類文章 (1)

最新文章

  • PICS! 2X12 Cab Reviews Mesa vs. Bogner
  • Q's about Korean PRS with P-90's.
  • aNY NEW duncan pickups next year ?
  • Fernandes Ravelle (Dave Kushner)
  • Another SX Tele question
  • GAS got the best of me yesterday....came home with new GEETAR!
  • Neck strength on Vintage ES330's amp; ES335's...
  • Awesome amp sampler site.
  • anyone try a fishman powerbridge?
  • Got My Custom Made Chassis (Pics)

最新留言

    動態訂閱

    文章精選

    文章搜尋

    誰來我家

    參觀人氣

    • 本日人氣:
    • 累積人氣: