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
Macro/Formula help by fgwiii
Hello, I am trying to run the following code as part of a macro and for some reason after I added additional entries to the ActiveCell.FormulaR1C1 = "=OR ...
June 19th, 2009 05:54 PM
by Luke M Go to last post
5 137
Looking up values in multiple rows by MeMe
Hi there, I need to have a vlookup or something that works across rows. For example, I have column A representing time, with A1 through to Axxxx with each...
(Multi-page thread 1 2)
June 19th, 2009 05:33 PM
by Neecy Go to last post
11 270
Count, Sum, and Filter by Color by Khalil
Dear Experts; My data is consist around 100 row, most them highlited with different colors; I need to do the following; Please help me 1.. Count by...
June 19th, 2009 05:06 PM
by Shane Devenshire[_3_] Go to last post
3 171
Insert cells function by Tom Haskell
When I attempt to insert a cell or group of cells the radio buttons to shift cell(s) right or down are grayed out. What is causing this? -- Thanks!
June 19th, 2009 05:06 PM
by Tom Haskell Go to last post
3 144
Format financial results to end in specific numbers by osbornauto
I have a one page spreadsheet with some financial calculations filling in a few cells as results. I'd like to have each of the cells end in a specific...
June 19th, 2009 05:03 PM
by JoeU2004 Go to last post
2 187
Filters by Muskrat24
I am using a filter to display rows with a "X" in column J. Some of the rows I always want to show,such as category titles, kinda like a default template....
June 19th, 2009 04:42 PM
by Gord Dibben Go to last post
3 109
Conditional Formatting by Philip Drury
I want to change the colour of cells A1:G1 if the value of G1 is K (make the row green), U (make the row amber) or S (make the row red). Really want this to...
June 19th, 2009 04:38 PM
by Gord Dibben Go to last post
3 156
import country flag in excel by Eckart
How can I automatically search for country flag symbols and import them into excel
June 19th, 2009 04:34 PM
by Gord Dibben Go to last post
2 308
COUNTIF calculates slow (10000+ records) by VidarHe
Hi, We have a printer repair log where we count the number of times the printer has been in based on the serial number. But we have 1000+ log entries and...
June 19th, 2009 01:16 PM
by VidarHe Go to last post
4 233
return values based upon specific guidelines by YaSso
Is there any function can return values based upon specific guidelines?
June 19th, 2009 01:16 PM
by DILipandey[_2_] Go to last post
2 125
Use custom [mm] formated value that is displayed in a calculation by WJPS
How can the custom formated value that is displayed in a cell be used in a calculation when it is the result of the difference between two dates entered as...
June 19th, 2009 12:47 PM
by Fred Smith[_4_] Go to last post
4 162
Data Validation Q by Seanie
I have the Data Validation detailed below, it does a couple of things for me, but how can I add an additional validation that will disallow the input of the...
June 19th, 2009 10:20 AM
by Bob Phillips[_2_] Go to last post
9 121
Can you rotate a section of excel cell data by Johnmcleanh
I want to rotate a selection of excel cells so that the column headings become the row headings. Can this be done? John
June 19th, 2009 09:04 AM
by mikebres Go to last post
1 104
Excel 2003 worksheet by Denver
Hi, I have an excel 2003 worksheet I have around 20 column headings I want to put a label so that I can identify what this column are store and instruction in...
June 19th, 2009 07:02 AM
by Roger Govier[_3_] Go to last post
1 119
Equals Sub Total Line by Jennifer
What function could I use if I want the info in the column to the right of the subtotaled column to always equal the subtotal below it? -- Jennifer
June 19th, 2009 05:27 AM
by Shane Devenshire[_3_] Go to last post
1 126
COUNTIF formula by Maxx
I have a spreadsheet with over 30,000 rows. I am am trying to use the COUNTIF formula to count the number of cells with specific text, but it doesn't seem to...
June 19th, 2009 05:24 AM
by Shane Devenshire[_3_] Go to last post
2 123
Auto Filter Comma Dilemiation by weswhite7
I have a spreadsheet and I would like to be able to limit the number of columns by using comma separations. If I have Column B and it has a list of 10 rows...
June 19th, 2009 05:20 AM
by Shane Devenshire[_3_] Go to last post
2 114
How to find min value in Excel text cells? by Jeff Kantner
Suppose I've got 5 cells, containing values 'b', 'd', 'a', 'e', 'c' ... if asked to pick the minimum value, you'd say 'a' (setting aside collating sequence...
June 19th, 2009 05:01 AM
by Shane Devenshire[_3_] Go to last post
3 150
Countif - Key words by PAL
I have multi-column, multi row spreadsheet. One of the columns is for a title. Is there a way to do a count of "key words". I was thinking like countif. ...
June 19th, 2009 04:52 AM
by Ashish Mathur[_2_] Go to last post
4 152
Shift roster in Excel by Ope726
How do I set up shift roster on Excel to show days/date of month
June 19th, 2009 04:46 AM
by Shane Devenshire[_3_] Go to last post
1 180
Post New Thread


Display Options
Showing threads 9961 to 9980 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 07:12 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.