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 Reverse Sort Order Last Post Replies Views
table of value ranges by $cruncher
What function can I use to analyze the numerical data in a spreadsheet and create a table of values? Such as x no of items within value range $0 to $600, x...
February 22nd, 2008 10:48 PM
by T. Valko Go to last post
2 72
Counting results from a lookup by &e7
I have a spreadsheet of data which I need to analyse results from. Two of the columns, 'severity' and 'priority' contain string values relating to the...
July 29th, 2009 12:46 PM
by &e7 Go to last post
1 94
How can I get the Analysis Toolpak by 'cole
In excell I need to get the add-in called analysis toolpack, but I don't have the CD (it's the schools) and I was wondering if there is any other way...
March 2nd, 2005 06:37 AM
by Myrna Larson Go to last post
1 156
Nested subtotals in incorrect order on large worksheets by 'Wyn
I have found that the higher level subtotals are in the wrong order on long spreadsheets. Has anyone else got this problem or solved it?
February 5th, 2010 06:04 PM
by Dave Peterson Go to last post
1 170
Cannot format data after using mid() function by ()
Have a strange problem after doing the following with Excel 2000 on a PC: 1. split up cell using text-to-column on: "(391.281, 15.220)" 2. Use MID(), e.g....
March 22nd, 2006 09:04 PM
by Duke Carey Go to last post
3 100
Using lookup functions with conditions and constantly changing dat by (-) Ions
I want to have a sheet in my workbook that looks through another sheet for a person's name (there will be many instances of each person's name) and checks a...
(Multi-page thread 1 2)
February 6th, 2009 11:45 PM
by Max Go to last post
11 163
Formula by ** Kris **
I don't know too much about formulas, but need a formula to look at a column of numbers and give me the number that repeated most often, and how many times it...
September 17th, 2004 08:41 PM
by Patti Go to last post
1 113
A change in date will reschedule all other dates by *** In need of your expertise*****
Am doing a planning file wherein dates may change. How do I make a simple insert function wherein when I change one date then the rest of the dates will...
October 8th, 2009 09:17 AM
by Jacob Skaria Go to last post
1 108
Excell convert formula row to formula column by **Danny**
Excel 2003 sp2. I have a row of formulas. I want to convert them into a column of formulas. AND conversely - column to row. On the same sheet or to a...
January 14th, 2007 11:03 PM
by Chip Pearson Go to last post
1 74
Auto size a pivot table to a page size by *.*
Driven mad by having to resize pivot tables constantly, printing and reprinting to ensure they fit to a page and are readable. There needs to be some way of...
August 23rd, 2006 05:09 AM
by steven1001 Go to last post
1 60
I have excel 2002 why doesn't it have a create list option under . by *Amber*
I am trying to do an assignment for school using excel and the instructions are to go to Data point to list and click create list but I don't have that option.
September 30th, 2004 09:27 PM
by *Amber* Go to last post
0 275
Grabbing data from a specific cell by *Kenneth*
Hello all, I’m trying to get Excel to grab data from a specific cell on an external spreadsheet through a pastlink and populate that data to 2nd...
March 18th, 2008 11:31 PM
by *Kenneth* Go to last post
2 88
relative formulas by *Scott
Is there a way to copy a formula so it stays relative to a cell on the preceeding worksheet. I need to have about 75 tabs that carry over totals from the...
April 16th, 2004 10:26 PM
by Gord Dibben Go to last post
4 230
$ for VLOOKUP functions by *Suzannah*
Hi :) can someone please tell me why the dollar sign ($) is necessary in the VLOOKUP function?
January 19th, 2007 09:26 PM
by Jim Thomlinson Go to last post
3 63
Vlookup question by *zot*
I'm using VLOOKUP to pull a value from a range if the number in C33 finds a match within that range. Here's the...
March 17th, 2009 10:08 PM
by T. Valko Go to last post
2 60
Poor humaneyes by *«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
August 23rd, 2007 06:25 AM
by *«Ë²´* Go to last post
0 46
Poor humaneyes by *«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
August 23rd, 2007 05:08 AM
by *«Ë²´* Go to last post
0 41
Poor humaneyes by *«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
August 23rd, 2007 05:08 AM
by *«Ë²´* Go to last post
0 40
Choose date from drop-down calendar by +alcheme
I'm creating a few different expense report and time card worksheets. I'd like to be able to choose a date from a drop-down calendar (i.e. easy access to...
August 8th, 2006 06:03 PM
by Duke Carey Go to last post
1 49
Large Function by ,
I have a spreadsheet with something similar to item below. I need to be able to find the oldest (largest) item for each person. Any and all help is...
December 2nd, 2003 10:02 AM
by Ron Rosenfeld Go to last post
1 84
Post New Thread


Display Options
Showing threads 341 to 360 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 04:21 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.