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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
conditional formatting 2 criteria in one row by gimpy
I would like to apply a conditional format in a row, where the first condition is that the value be greater than the cell on the left AND equal to the one on...
May 18th, 2009 06:00 PM
by FSt1 Go to last post
3 177
Averaging Data continuously when using Filter function - Need Help by MGray
Need formula to average column of numbers as is, and as they will be as I sort by using the Filter. I can do this for total counts using the...
May 18th, 2009 05:45 PM
by Luke M Go to last post
3 175
format of zero value by willemeulen
When changing the cell to accounting format all 0 (zero) values change to - Are there more options available, in particular I would like it if 0 (zero) would...
May 18th, 2009 05:29 PM
by JoeU2004 Go to last post
3 147
Multiple listboxes to update pivot table? by Cam
Hello, I have a listbox that when selected, update the pivot table (change the variable pivot field called "Machine") based on the selection on the listbox....
May 18th, 2009 04:55 PM
by Roger Govier[_3_] Go to last post
1 231
Data Entry by jojoba
I want to create a workbook such that users can enter data (using a data form like page) but once data is entered, it cannot be changed on the spreadsheet. I...
May 18th, 2009 04:49 PM
by Jamo via OfficeKB.com Go to last post
4 267
convert 5 characters in a cell to 6 characters by adding a zero by Helenf
Thank you in advance I have 2 different spreadsheets of about 18000 lines each of products. The item codes on sheet one muct match the ones on sheet 2....
May 18th, 2009 04:43 PM
by Helenf Go to last post
4 150
How to use union reference operator? by JoeU2004
Why doesn't the union reference operator work below? Suppose J24:J28 contains 11,20,31,43,53, and K24:K28 contains the text grp1,grp2,grp3,grp4,grp5. And...
May 18th, 2009 04:37 PM
by T. Valko Go to last post
4 166
Error when copying worksheet by Mike
I am experience a problem when copying worksheets. I have a workbook with about 9 worksheets. The size of the workbook is about 1 MB. When I right click on...
May 18th, 2009 04:36 PM
by Mike Go to last post
0 139
Cell Fill Format & Sort Question by Scott
I have a column with 144 rows. In alternating rows, I have a solid fill to make the spreadsheet easier to read, especially when printed. However, when I...
May 18th, 2009 04:36 PM
by Sheeloo Go to last post
1 170
Fill handle fill down alternative methods question by Rufio
All, I have a spreadsheet that has 160,000 rows and I am having trouble with the incorporating the fill handle to fill down values on a new column based on...
May 18th, 2009 04:28 PM
by Sheeloo Go to last post
1 188
MS Excel, Cell-Pionter Options by Fabco-User
In Ecel, can the cell-pointer highlight the entire ROW and COLUMN as it is moved around the spreadsheet? It currently highlights the borders, but it would be...
May 18th, 2009 04:12 PM
by Fabco-User[_2_] Go to last post
2 168
Cell Capture Multiple WorkSheets? by Ken
Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet contains a value I wish to capture in a single worksheet Col. I can select each cell...
May 18th, 2009 03:49 PM
by Marcelo Go to last post
2 182
Insert\Charts section is not working in excel by K[_4_]
Hi all, I am using excel 2007. I have one excel file in which I had few graphs. I deleted all the graphs and charts as I wanted to create new one. Since I...
May 18th, 2009 03:48 PM
by K[_4_] Go to last post
0 161
Can Office 2007 open lotus files? by Mike Tintle
Can Office 2007 open lotus files? -- Mike Tintle
May 18th, 2009 03:44 PM
by FSt1 Go to last post
1 216
return a formula instead of a value of a cell by willemeulen
Is it possible to let excel return a formula instead of the cells value. At this stage I need to write all possible formula's for each cell (vlookup will...
May 18th, 2009 02:51 PM
by Gary''s Student Go to last post
2 164
If i open a 2003 excel document in excel 2007 can i edit it ? by kt
Can I edit my old spreadsheet using the new features? I don't want to re-do the entire spreadsheet!
May 18th, 2009 02:47 PM
by Bob Umlas[_3_] Go to last post
1 169
SUMIF is not update why? by vlook fomula
Dear all, I am facing problem in SUMIF formula and problem is: I have applied SUMIF formula and linked with another file not, when I try to open this file it...
May 18th, 2009 02:36 PM
by Sean Timmons Go to last post
3 135
match vlookup function by Wanna Learn
Hello A report is send to me has 27 columns and at least 900 lines I need 3 columns column a name of customer column c has type of transaction ...
May 18th, 2009 02:34 PM
by Dave Peterson Go to last post
4 156
SUMPRODUCT FOR MULTIPLE SHEETS by FARAZ QURESHI
How can I use a formula like: =SUMPRODUCT(--(Jan!$H:$H=$A3)*--(Jan!$J:$J=B$1)*--(Jan!$J:$J=B$2),Jan!$J:$J) for multiple sheets? Following formula is not...
May 18th, 2009 02:16 PM
by Domenic[_2_] Go to last post
5 189
Insert to today's date by SPISO
I have a dashboard type of display on worksheet #1 (Dashboard) where an individual updates a cell B3 through out the day, everyday, with a new value. On...
(Multi-page thread 1 2)
May 18th, 2009 02:11 PM
by SPISO Go to last post
16 224
Post New Thread


Display Options
Showing threads 19961 to 19980 of 139764
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 08:20 PM.


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