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
Counting 3 columns? by Owen
I have 3 columns with different text values. I want to know the # of times col a = texta, and col b=textb and colc = text c - how do I do this in excel?
November 9th, 2009 01:01 AM
by JLatham Go to last post
2 122
Counting ? by Owen
I have a spreadsheet with 3 columns - I want to know the number of times col A = texta, and col b = textb and col c = text c. how do I do this in excel?
November 9th, 2009 12:58 AM
by Gary''s Student Go to last post
1 116
CountIf formula by Verne
I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new row, that row is not included in the formula. What can I do so it is included....
November 9th, 2009 12:09 AM
by Zhi Sheng Go to last post
4 166
formulas by Cazza
Hi. I'm hoping someone can understand what I am trying to do and point me in the right direction of where I can learn to do it. I want to have a 2 sheet...
November 9th, 2009 12:04 AM
by Zhi Sheng Go to last post
2 114
Number format TextBox? by hoyos
How do I number format this code to read ("###0") ..Range("J188") = .Range("J187").Value
November 9th, 2009 12:04 AM
by hoyos Go to last post
2 140
printing setup issue in 2007 by Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on both sides, and in "print what" area choose "active sheet(s)", all tabs will be...
November 9th, 2009 12:00 AM
by Zhi Sheng Go to last post
1 126
printing setup in excel 2007 by Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on both sides, and in "print what" area choose "active sheet(s)", all tabs will be...
November 8th, 2009 11:59 PM
by Zhi Sheng Go to last post
0 178
printing setup in excel 2007 by Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on both sides, and in "print what" area choose "active sheet(s)", all tabs will be...
November 8th, 2009 11:59 PM
by Zhi Sheng Go to last post
0 118
printing setup issue in 2007 by Zhi Sheng
while in 2003, if i select multi tabs(sheets), set the printer to print on both sides, and in "print what" area choose "active sheet(s)", all tabs will be...
November 8th, 2009 11:58 PM
by Zhi Sheng Go to last post
0 135
Find Cut and paste by kingie
Hi, I have a large amount of data containing unique codes. I want to type in a list of codes and the program to find them in worksheet 1 Cut and paste it...
November 8th, 2009 09:33 PM
by kingie Go to last post
4 123
User Defined Functions by MoTrekker
I imported a Excel 2003 spreadsheet with UDFs and the UDFs are not found. Additionally, I have tried to rebuild the UDFs in 2007 and I can't get the...
November 8th, 2009 07:36 PM
by Barb Reinhardt Go to last post
2 146
Different cells that need to sum in one by Cbdavis
I have one cell that needs to contain the possible sum of cell (A1*B1) or (C1*D1) or (E1*F1) but only one of the 3 possibles For example : A1 is $10.00 B1...
November 8th, 2009 04:10 PM
by Cbdavis Go to last post
4 152
Deactivating a macro button by Victor Delta[_2_]
I have a macro in a spreadsheet which is linked to a toolbar button in the usual way. Is there any way please that the button can be deactivated (and if...
November 8th, 2009 03:07 PM
by Victor Delta[_2_] Go to last post
2 132
Jululian Excel by George A. Jululian[_2_]
Hi all, i have table as below A B C D E F G Date Retail car Fleet Car Total car Retail turck Fleet Truck Total Truck Colunm A date from January...
November 8th, 2009 11:49 AM
by Jacob Skaria Go to last post
3 123
Excel Function by Nasr Mostafa
Hi What is the formula to get the following Mark Points 90 & more 4 85 & less 90 3.7 82.5 & less 85 3.3 77.5 & less 82.5 ...
November 8th, 2009 11:45 AM
by Ron Rosenfeld Go to last post
1 102
How do I lock certain cells in excel 2007? by Dr Alok Modi MD
My query is as follows : I have created an excel sheet that automates the billing procedure of my hospital. It has multiple complicated formulas that i have...
November 8th, 2009 11:42 AM
by Arceedee Go to last post
1 114
Header in row to column by Venice
I have the following data: Row 1 has 3 columns that is B1 = Opening, C1 = Spent, D1 = End balance. From E1 to G1 it has the same header. Every 3 columns has...
November 8th, 2009 09:26 AM
by Jacob Skaria Go to last post
1 114
Sort data in rows to column by Venice
I would need to re-arrange the format of the data. My current data is: In row 1, every 3 columns has headers Opening, Spent, End balance (ie A1 is Opening, B1...
November 8th, 2009 08:40 AM
by Jacob Skaria Go to last post
1 121
how to average a range of cells and ignore #div/0! answer by Vince
How do I average a range of cells that are blank until data is entered later with out the destination cell returning a #div/o! error
November 8th, 2009 06:23 AM
by FSt1 Go to last post
4 197
hyperlink to cell based on formula results by nba
I am using a formula to set conditional formatting to display bookings on a calender. I want to hyperlink from the calender sheet to the sheet that has the...
November 8th, 2009 06:21 AM
by Jacob Skaria Go to last post
5 173
Post New Thread


Display Options
Showing threads 10341 to 10360 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 01:01 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.