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
Count If equals x AND y by Nadine
Excel 2003 Col A Col B Col C 1 No Count this cell I need to count all the cells in Col C if Col A=1 and Col B=No Thanks.
May 5th, 2010 09:11 PM
by Nadine Go to last post
9 185
validation by ganga
hi, I have a workbook with 2 sheets. In one sheet I have a calender and other sheet just list of names. what i want to do is: In the calender sheet if i...
May 5th, 2010 08:54 PM
by ganga Go to last post
0 104
How to freeze one column vertically, one horizontal in same sprdsh by sweaver
Is it possible to freeze a column vertically and one horizontally in the same spreadsheet?
May 5th, 2010 08:47 PM
by Nadine Go to last post
4 155
How do I set up a botton on Excel 2003 to go to the next sheet? by Bruce
I want to create a "Next Page Button" on an Excel 2003 spreadsheet to go to the next sheet. When entries are complete a person can just click the "button"...
May 5th, 2010 08:23 PM
by Bob Umlas, Excel MVP Go to last post
1 143
hr worksheet counting days missed by Tina
I currently track employee time for the purpose of tracking vacation time. Now my bosses would like to add a function that will alert if an employee is...
May 5th, 2010 08:10 PM
by trip_to_tokyo[_3_] Go to last post
2 123
Excel 2007 Pivot Tables compatible with 2003 by Jimmy G
I am running Office 2003, but I have been sent pivot tables created by a colleague in Excel 2007. The workbook is being saved as an *.xls, but when I try to...
May 5th, 2010 08:01 PM
by bala_vb[_8_] Go to last post
3 167
how to remove #n/a error in excel vlookup b/c value is not found? by B. Franklin Saunders
I'm using vlookup in excel to pull select data from a worksheet. The problem is that the value I'm seeking isn't always in the table array. So, I get a...
(Multi-page thread 1 2)
May 5th, 2010 07:48 PM
by Lisa Kansas City Go to last post
18 400
Graph Paper by Rainchild
How do you make graph paper with 2 square cm in Excel?
May 5th, 2010 07:33 PM
by Billns Go to last post
2 279
Top 10 in pivot - show rest as other or similar by Kenneth Andersen
Hi I need to create a pivot table .... it could be revenue per. country. Let us assume that there are 30 countries. I only want to display top 10. I can find...
May 5th, 2010 07:03 PM
by Herbert Seidenberg Go to last post
3 1,112
vlook on different tabs based on value by jatman
good day, i have the following so far in my macro: .... supcode = Range("B4").Value .... If supcode = "CLI" Then ActiveCell.Offset(0, 4) =...
May 5th, 2010 06:48 PM
by Luke M[_4_] Go to last post
1 134
Lookup / Summary Table by Joe
I want Excel to lookup a value in a table and return each row it finds that value in. As an example: Lookup Value: Ford Lookup Table: A1: Ford B1: Focus
May 5th, 2010 06:47 PM
by Steve Dunn Go to last post
8 153
insert blank row and formulas by scottmcm
when I insert a new row in my worksheet, I noticed it does not update the formulas for any row below that line that reference another sheet in my...
May 5th, 2010 06:44 PM
by Luke M[_4_] Go to last post
1 138
May 5th, 2010 06:36 PM
by Bernard Liengme Go to last post
2 126
VLOOKUP by PAL
I am using VLOOKUP as I have many times in the past. The formula I am using is: =VLOOKUP($A3,Raw,2,FALSE) It returns a "0" presumeably becasue it thinks...
May 5th, 2010 06:27 PM
by Tom Hutchins Go to last post
2 106
Combining cells with text by Nadine
I have two cells that both have text in them. Cell A2 contains the old status. Cell B2 contains the new status. I'd like to keep the history of the old...
May 5th, 2010 06:23 PM
by Nadine Go to last post
2 152
Duplication by Lorenza@hsccs
How do I duplicate a worksheet and contents 20 times in a workbook?
May 5th, 2010 06:10 PM
by Dave Peterson Go to last post
1 87
WEEKNUM function not working by Cam
Hello, I have a cell to calculate current week number, =WEEKNUM(TODAY()) and I have the analysis toolpak checked in the Add-In menu, but it still result...
May 5th, 2010 06:07 PM
by Dave Peterson Go to last post
4 123
I want a footnote number (small number) at end of sentence? by tallcat4000
I want to put a footnote (small number raised higher than rest of sentence) at the end of my notation on a report. How do I find this "symbol"?
May 5th, 2010 05:34 PM
by Bernard Liengme Go to last post
2 125
How do I write a formula in excel where 1 = .05 and 2 = .75 etc. by CarolB
How do I write a formula in excel where 1 = .05 and 2 = .75 and 3 = 1.23? So, if the number entered in the cell is 1 then .05 is muliplied by another cell.
May 5th, 2010 05:23 PM
by Mike H Go to last post
2 110
conditional formatting by Russell
I want to be able to search for two things in a column. The first is a value of less than or greater than $100. (OK so that is really two things I guess)....
May 5th, 2010 04:58 PM
by Russell Go to last post
3 125
Post New Thread


Display Options
Showing threads 761 to 780 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 03:26 AM.


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