PIXNET Logo登入

software

跳到主文

software

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

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 7月 20 週四 200620:08
  • why can't I access conditional formatting?

I cant seem to acces the conditional formatting thing in the formulas pull
down.I would really like to use this feature, It just is always unavailible
If your workbook is shared, CF is unavailable. See 'Features that are
unavailable in shared workbooks' in help
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(1)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • double clicking .xls file doesn't open application

I just loaded MS Office 2003 and have found that when I attempt to open
documents (files) saved in Excel I get the following error.
Error message: Windows cannot open this file. quot;To open this file, Windows
needs to know what program created it. Windows can to online and look it up
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(5)

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

I have a spreadsheet in which 900 cells contain a paragraph of HTML and text.
I need to delete this paragraph from every cell. How can I do it all at
once? Find and replace doesn't allow it.
Thanks!
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Formala to find the best/latest signal

Hello,
I have a series of rows 14000 lines strong in an excel sheet.
The series contain caribou location reports from those caribou that have a
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Can you enter @ symbol without becomig email address in a cell?

I am trying to enter information in a cell, i.e. 4@50. It keeps turning the
information into an email address. How can I stop this?
Hi
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • COUNT using multiple conditions


I need excel to count the number of rows which contain both of two
conditions in seperate cells. the condtions are a specified number AND
a specified letter, if the row only contains one of either conditions i
need excel to ignore it, but if it contains both then count it as one.
I have used the SUMPRODUCT function but it doesnt seem to work, im
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Display adjacent cell as result...

Hello Gang:
I have two colums, Column A (Val1) and Column B (a number such as 456). If
I use the expression =max(b1:b10) I get the highest value for that column,
but what what I need is the adjacent cell name such as Val1.
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

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

I have ytd information in columns A-L that are subtotaled by expense
classification. Subotalling is done in Pivot Table. This information is
imported into the spreadsheet via macro. In columns M-P, I have monthly
information that is imported via Vlookup. I tried have the Pivot Table
produce both ytd and monthly results, but I could not get all of the ouput in
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

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

taking a group of payments in column A, my smallest monthly payment is 10.28.
For some reason it is not coming up correctly. How do I set this funciton up
Thanks for you help
--
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do I use a keyboard to change a PivotTable or delete a field?

I am trying to test the accessibility of Excel for manually working with
PivotTables. I can't find a way to manipulate the tables using just the
keyboard, and if I place a field (using keyboard or mouse) in a PivotTable, I
can't find a way to delete it or put it back into the PivotTable Field List.
Using the Data menu wasn't any help, either.
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

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

個人資訊

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

熱門文章

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

文章分類

  • 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)

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

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