A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Vertical lookup of pictures by DJDKAL
I am trying to see if there is a way to lookup a picture in one tab and insert it into another tab all within the same worksheet. I have tried the embed...
(Multi-page thread 1 2)
March 22nd, 2010 04:24 PM
by Gord Dibben Go to last post
14 163
Shade a Cell by eddie57
How can I shade a cell in Excel 2003 but when I print the document for it not to print the shading? Thanks in advance.
March 22nd, 2010 04:16 PM
by Gord Dibben Go to last post
7 191
Stolen Laptop by FindStolenLaptops
http://find-stolen-laptops.com/wp-content/uploads/2010/03/never_know.jpg Use Snuko Anti-Theft Software to trace your lost or stolen laptop. It's easy to use,...
March 22nd, 2010 03:19 PM
by FindStolenLaptops Go to last post
0 63
formula for displaying only the last entry of a group of cells by Steve
How do you write the formula that will display only the latest entry in a succession of entries? For example, if I have 12 months in 12 columns, and the 13th...
March 22nd, 2010 02:34 PM
by Bernard Liengme Go to last post
2 77
IF, INDEX and MATCH by LJ
I was using the formula below to match 2 indicators listed within an array. I have another 2 indicators that I CANNOT add to the array. They lie in cells AA2...
March 22nd, 2010 02:25 PM
by Bernard Liengme Go to last post
1 69
the criteria pane and table panes have disappered. by llewelwa
In my excel file I can't see the criteria and table panes and the functions will not reappear.
March 22nd, 2010 02:25 PM
by llewelwa Go to last post
0 86
How do I stop text from disappearing when I wrap text in Excel? by Shavonne
When I type in a cell then wrap text, my text no longer displays in the cell. I can see it in the formula bar and in print preview but not in the actual...
March 22nd, 2010 01:38 PM
by Shavonne Go to last post
0 81
Using match but data needs to be split. by gyzmo
I have a table - Y axis contains whole numbers (1 - 20) and X axis contains decimals (0.1 - 0.9). For each there is a corresponding reference that I want to...
March 22nd, 2010 11:14 AM
by Mike H Go to last post
2 67
Cell Formats & Hiding by Greendistantstar[_2_]
Hi I have a worksheet I use frequently, where some cells have zero values. For presentation's sake, I hide rows where the value is zero, and this I do...
March 22nd, 2010 09:18 AM
by minyeh Go to last post
3 87
Formula help for beginner by Wincleaner
Hello, All I want to do is Column C is an amount Column D is a drop down list of Paid, Unpaid, Cheque If Column D = Paid or Cheque I want to calc the sum of...
March 22nd, 2010 03:40 AM
by Ashish Mathur[_2_] Go to last post
3 104
no respond/answer from formula entry by Tanisha
I,m entering a formula but when I ht enter ther is no answer/total the formula looks like this:=b2*(b3/(1-b6)):so b2=11,459,713.00 b3=13.40 b6=39.25% when...
March 22nd, 2010 02:43 AM
by Teethless mama Go to last post
1 83
Freeze the side column/top row & scroll others by goadk123
what is the function to set (lock in or freeze) the first column and / or top row of a spreadsheet, so the words and numbers remain in the same place as you...
March 22nd, 2010 02:36 AM
by Teethless mama Go to last post
2 75
How to calculate text according to multiple months? by Joona
Hello! I', having a slight problem with my Excel-worksheet. I have a sheet with data, like this: A B 1.1.2010 X 2.2.2010 ...
March 22nd, 2010 02:35 AM
by T. Valko Go to last post
6 75
Using Mid Function with Pivot Table Calculated Item by Simon
Hi, I'm using excel 2007, I have a pivot table and I'm trying to create a calculated item, the formula for the Calculated item is: IF(MID('Project...
March 22nd, 2010 01:07 AM
by Simon Go to last post
0 74
How do I copying data from a cell on sheet to a diff cell/sheet by Bowldiva120
It data entry of scores on worksheet one that has to be automatically copied to worksheet 2. Once I entry the data on wksht 1 want it placed on wksht 2. I...
March 22nd, 2010 12:25 AM
by Max Go to last post
1 76
Conditional Formatting Assistance by wendy
Hello, I have a spreadsheet that contains multiple columns containing text. I would like to highlight the unique values that exist in all other columns...
March 21st, 2010 06:49 PM
by Rick Rothstein[_2_] Go to last post
4 73
Combine macros variable help by Ephraim
So I've recorded a number of macros that each hide a different Week. Sub Macro1() ' Macro1 Macro Application.Goto Reference:="Week1" ...
March 21st, 2010 02:52 PM
by Don Guillett[_2_] Go to last post
2 74
Convert Array Formulas to Regular Formulas by minyeh
On Mar 19, 9:23*pm, Domenick wrote: When I manually correct these spreadsheets, I have to select all the cells that...
March 21st, 2010 06:55 AM
by minyeh Go to last post
0 72
summaries on alternative sheets by Mr L Hibbert
hello im trying to compile a small folder consisting of different worksheets, each worksheet is a different customers sales etc.... with totals for JAN, FEB...
March 21st, 2010 06:45 AM
by minyeh Go to last post
6 81
Indirect formulas in cells not holding cell format after copy by Cathy[_6_]
Hello. I have a bunch of indirect forumlas in cells that are taking values from another open workbook. I use the copy and pastespecial method to get the...
March 21st, 2010 06:39 AM
by David Biddulph Go to last post
3 89
Post New Thread


Display Options
Showing threads 1921 to 1940 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.