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
Date formula rounded up by Newfie809
June 30, 2010 A B C D Birth Date Date of Hire Appt....
May 28th, 2010 10:09 PM
by Gord Dibben Go to last post
2 771
Invisible Column names and Row numbers by Suresh Lohar
Friends, I received a work sheet from my friend which has data from a1 to m60. But surprisingly after the column M, whole letters are invisible and same in...
May 28th, 2010 09:53 PM
by Gord Dibben Go to last post
2 731
how to compare the old code and new code? by Pradeep_ji78
I have old code and old description in my excel. Now company given me new code with same description. I want to compare the old code with new code but...
May 28th, 2010 09:51 PM
by Gord Dibben Go to last post
2 685
Count using IF / AND by RERAA
If cell B3 is between a number range and another cell in same Row =(Z) count. As cells are populated the count will increase. So the cell must be between 10...
May 28th, 2010 08:51 PM
by Ron@Buy Go to last post
2 902
ranking by liem
How can I rank the top 5 or 10 items in the category for a location. Location PSA Category item Day 1 day 2 day 3 day 4 day 5 day 6 1501 ...
May 28th, 2010 08:39 PM
by Luke M[_4_] Go to last post
1 722
Date inconsistent help please :) by daisy
Is it possible to clean up a date field where someone was keeping an excel sheet but the date field is a mess For example he has 1998 2/2005 1/1/2010 We...
May 28th, 2010 08:37 PM
by daisy Go to last post
3 818
Question About Importing Columns From A Datasheet to A Worksheet by M.J.Goode
I am asking for any help you can give me regarding the best way to import columns from a datasheet into another worksheet. I have many worksheets to...
May 28th, 2010 08:19 PM
by M.J.Goode[_2_] Go to last post
4 888
Format Date by Malcolm
Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm
May 28th, 2010 06:46 PM
by Malcolm Go to last post
6 743
Referencing another workbook using a variable for the sheet? by Doug
=sheet1!A1 Is it possible to make the "sheet1" portion of this formula tied to a cell in the destination workbook so that if I type "sheet2" in cell A3 of my...
(Multi-page thread 1 2 3)
May 28th, 2010 06:45 PM
by Doug Go to last post
20 1,751
Convert Week number into Month by KT
I have a worksheet with values for year and week number. I need to convert these to the descriptive month name. Some weeks cross month ends, but this is...
May 28th, 2010 06:23 PM
by Lars-Åke Aspelin[_4_] Go to last post
4 878
How do I shorten an IF formula? by FJM
How do I shorten this formula. It is missing information from the missing rows, but if I put those in, it tells me "The specified formula cannot be entered...
May 28th, 2010 06:01 PM
by Gord Dibben Go to last post
7 841
Formula Help by Nikki
I would like to remove every character up to the "_" and retrieve the name to the right. Can someone please help me with a formulat that would work for...
May 28th, 2010 05:40 PM
by Nikki Go to last post
4 638
Pivot Excel 2007 by Dinesh
Hi, Somehow my Pivot table is not summing up rows at the end when I have more than two data field in excel 2007. It does sums up by columns. Does any one...
May 28th, 2010 05:02 PM
by Dinesh Go to last post
2 898
Thanks Everyone by ryguy7272
Thanks everyone, for all the help over the course of the past couple years. This has been an unbelievably rich venue for learning the ins and outs of Excel....
May 28th, 2010 04:48 PM
by ryguy7272 Go to last post
0 607
Linking to external files by Mike
I am trying to use and external link that is updated each week based on a week numbered file as below =VLOOKUP(E3,'G:\Mike\In progress\Sameday Product...
May 28th, 2010 04:23 PM
by Don Guillett[_2_] Go to last post
1 697
IF OR AND in same conditional formula by Ron
I'm setting up a conditional formula to use in a conditional format, where depending on a couple of different conditions, the cell with the date entered will...
May 28th, 2010 04:18 PM
by Ron Go to last post
2 710
Fill last row down for large selection? by msnyc07
A few months ago someone posted a great solution for the following problem which doesn't seem to be working all of a sudden; I have a column with values...
May 28th, 2010 03:33 PM
by Steve Dunn Go to last post
1 754
Get column headings to float when scrolling down? by Wendy
How do I get the first three or four lines where I have typed in my column headings to "float" down as I'm entering information in the lines below?
May 28th, 2010 03:32 PM
by Gord Dibben Go to last post
3 700
Averaging a column that contains text by Malcolm
On my worksheet I have a column of12 cells that I need to average. Unfortunately cell B6 contains text (see below). As shown the dreaded #DIV/0! displays in...
May 28th, 2010 03:31 PM
by Malcolm Go to last post
4 673
some help or direction on using excel by KC
cutting to the chase. what i'm trying to do is i have a report that i import from one program to an excel spreadsheet, based on the information in that...
May 28th, 2010 03:26 PM
by Gord Dibben Go to last post
1 675
Post New Thread


Display Options
Showing threads 201 to 220 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: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.