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
Problem with Syntax? by MurrayBarn
2 B C D E 3 PolicyStartDate Class ClassTotal VAT 4 01/11/2008 Motor 10,039.24 1,232.89 5 01/11/2008 Motor -200.00 ...
June 12th, 2009 01:45 PM
by MurrayBarn Go to last post
8 176
Go to a chosen worksheet by Bob[_53_]
I am trying to create a simple index page as the first sheet in workbook. The book has over 20 worksheets in it. On sheet1 I would like to have a dropdown...
June 12th, 2009 12:59 PM
by Jacob Skaria Go to last post
1 175
macro to grab current workbook filename by TR Young
Excel 2003: I need a macro that grabs the current workbook filename and drops it into cell A2. I know this is simple, but my head is fried this evening....
June 12th, 2009 12:41 PM
by Eduardo Go to last post
3 214
Help: Assigning a "word" a numerical value by Eric
I am trying to assign a word a value for percentage computations. I want to assign the word "UP" the value of "1" and the word "down" a value of "0" for...
June 12th, 2009 10:02 AM
by Jacob Skaria Go to last post
1 118
Filter in Rows not columns by Russell
I would like to be able to apply a filter (an autofilter) down a column, so that I can filter certain columns. Rather than use the convenstional method of...
June 12th, 2009 10:02 AM
by Russell Go to last post
3 236
Less than, Greater Than, equal to conditional formatting by Lee West
I have a spreadsheet that i need to use to calculate children's reading ages against their real ages with a 6 month swing either way, using a 3 colour...
June 12th, 2009 08:37 AM
by Lee West Go to last post
4 164
Countif cell is conditionally formatted by RicG
Each row of a table is conditionally formatted to show the largest number in the row. I would like to count the total number of highlighted cells in each...
June 12th, 2009 08:26 AM
by David Biddulph Go to last post
1 121
Hiding columns in Excel 2003 by Les
Hi, I do know how to hide columns but I have a problem. Say I have a worksheet which person A uses columns A through T. I plan on using columns AA and AB...
June 12th, 2009 06:40 AM
by Harlan Grove[_2_] Go to last post
2 134
inverse weighted average by Harlan Grove[_2_]
Dan Cotts wrote... I am trying to figure out how to do a weighted average using a reverse ratio - that is, I have...
June 12th, 2009 06:05 AM
by Harlan Grove[_2_] Go to last post
0 153
Inverse wieghted average/ratio by dtacotts
I am trying to figure out how to do a weighted average using a reverse ratio - that is, I have members of a group, each with Income, that I need to allocate...
June 12th, 2009 05:21 AM
by Jim Cone[_2_] Go to last post
1 113
Sums including #NAME? by Fred Holmes
Excel 2000 How do I get a SUM() formula to ignore (disregard) any #NAME? errors in the range being summed, and produce (evaluate to) the sum of the valid...
June 12th, 2009 04:54 AM
by Fred Holmes Go to last post
2 117
Trying to highlight cells that have the same value as the active c by Excel_Rookie
I want to be able to highlight all the cells that have the same text as the active cell? So if I'm on G8 and that cell has the word Apples then I want to...
June 12th, 2009 02:45 AM
by Jacob Skaria Go to last post
9 192
Remove last n rows by Colin Hayes
HI I have an excel problem I hope someone can help with. I need a small macro which , via popup , will allow me to remove the last n rows of a...
June 12th, 2009 02:34 AM
by Colin Hayes Go to last post
6 114
count number of occurances between 2 values by Peters
I am trying to count how many cells contain a number within a certain range eg number of cells in a column that are between 1000 and 2000. I thought i could...
June 12th, 2009 02:17 AM
by smartin Go to last post
3 147
Sort Block of Data by lab-guy
Hi All - I have a large block of data, 25 x 25. (classes going down, students going across) At the intersection, I have a concatenate formula grabbing...
June 12th, 2009 12:46 AM
by CLR Go to last post
3 127
How to import PDF into Excel? by JoeU2004
I want to import some data from PDF files into Excel. Is there a straight-forward way to do this? For example, see...
June 12th, 2009 12:29 AM
by JoeU2004 Go to last post
1 170
Sumproduct with blanks by EZ[_2_]
I have been using SUMPRODUCT for a while, and so far it's great. I'm trying to use it on data range with blanks. My data is arranged as 52 weeks/rows for...
(Multi-page thread 1 2)
June 11th, 2009 11:55 PM
by EZ[_2_] Go to last post
10 211
Eliminating Duplicates in Excel 2007 by Té
I have a customer name (Tina) and numbers that go with Tina's information (575, 125, and 700). How can I find the highest number, and delete the other...
June 11th, 2009 11:19 PM
by Té Go to last post
2 128
How do I copy subtotaled data without underlying details in Excel by Diletto
I have a large sheet of data that I have subtotaled. I am trying to copy just the top layer over to a new worksheet. HOwever, it pulls all the data below...
June 11th, 2009 11:06 PM
by Shane Devenshire[_3_] Go to last post
1 123
How can I convert many rows of hyperlinks to BASE links? by EnduroGal
Hi, there! I have a spreadsheet consisting of several hundred rows, and in Column F of each row is a hyperlink consisting of the word "detail." Each of...
June 11th, 2009 11:03 PM
by Shane Devenshire[_3_] Go to last post
2 131
Post New Thread


Display Options
Showing threads 10181 to 10200 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:39 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.