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
Cell to return a specific value if left blank by Sdtex
Just a novice, so please bear with me. I'm trying to set up an inventory system where 1 is the most common amount, yet I would also like the "quantity"...
May 15th, 2009 06:30 PM
by Jacob Skaria Go to last post
6 131
Sorting by teh_chucksta
how can I sort a column with numbers and text in descending order where the text falls to the bottom and not the top? thanks, charlie
May 15th, 2009 05:55 PM
by Mike H Go to last post
2 99
numbers and macros by Evil with a K
I have a couple of questions regarding managing the enormous amount of data I see everyday that I simply cannot find a way to execute it in an excel Macro....
May 15th, 2009 05:27 PM
by Jacob Skaria Go to last post
3 103
VLOOKUP by Gary T
I'm trying to find exact matches from Sheet 1 to Sheet 2, and to show a zero value if there is no match. Can't seem to get the formula...
May 15th, 2009 05:09 PM
by Teethless mama Go to last post
2 89
Sum on multiple columns with search criteria by steve711
I am trying to sum a column if the criteria matches for two other cloumns across different spreadsheets or tabs. However, one of the colums has a text...
May 15th, 2009 04:45 PM
by T. Valko Go to last post
3 111
Sumif / Countif by Blue
Hi is there any way that i can use 2 arguments for sumif & countif functions instead of just 1? -- Lois
May 15th, 2009 03:50 PM
by Teethless mama Go to last post
3 73
VBA to ask for file location and use to open DB by Brian[_16_]
Howdy All, This is part of what I hope to be a large project... I have created a button, that when press, will prompt the user to browse for an .mdb...
May 15th, 2009 03:36 PM
by Dave Peterson Go to last post
4 95
COUNTIF: criteria is a format by alligatormaki
I have a column with cells that have text of different colors. I'm trying to count up the number of cells that the text is formatted a particular color. ...
May 15th, 2009 03:24 PM
by [email protected] Go to last post
2 89
Disabling copy/paste hidden cells by Shawn
There is an odd quirk between Excel and Outlook in that if you copy a range of filtered data and past the table in an Outlook e-mail and send it out, in the...
May 15th, 2009 01:15 PM
by Shawn Go to last post
2 88
Use string value for database location - VBA by [email protected]
I posted earlier, but I think I may have been too obtuse. I have a string value: Dim DBLocation As String Then I have a database connection which I want to...
May 15th, 2009 01:06 PM
by Dave Peterson Go to last post
1 136
How to enable the Unprotected Worksheet menu by xx
1) In Excel, I protected the worksheet and sheet. Then clicked Shared Workbook and Shared Workplace. After that, when I unprotect the file, the drop...
May 15th, 2009 12:50 PM
by Eduardo Go to last post
1 108
Data manipulation help by Brian[_16_]
Howdy all, I have employee records with corresponding image files list all in Column A. Each employee record is proceeded by the word BEGIN:, then SSN, NAME,...
May 15th, 2009 12:40 PM
by Brian[_16_] Go to last post
9 136
how do i retrieve an excel spreadsheet i was working on by robbieliam
i have been working on a spreadsheet for the last 4 days and have been saving entry's at regular intervals somehow i have lost all the data i have entered...
May 15th, 2009 12:21 PM
by Eduardo Go to last post
1 72
Increased percentage question by Brian
I am trying to determine how to go about generating a formmula for Excel which will assit in working out a percentage increase. The scenario is as...
May 15th, 2009 10:50 AM
by Gary''s Student Go to last post
3 81
Return Formula by willemeulen[_5_]
I constructed a lookup table with formula's on the second sheet which I want to use to return a working formula on sheet 1. Example Shape Code 39: Formula...
May 15th, 2009 10:08 AM
by willemeulen[_9_] Go to last post
8 176
Excel Table Conditional formatting not doing what I want by ECH123
I have two tables in Excel 2007, first table details actions, tasks etc for different individuals stating a critical date –ie date by which their action...
May 15th, 2009 09:48 AM
by ECH123 Go to last post
2 88
Macros by JulianB
I have set up a macro in excel 2003, however, i can't run it in excel 2007. I get many messages. "Save as *xps???? The dedug shows "print out" as my...
May 15th, 2009 07:01 AM
by Kassie Go to last post
1 106
Macro to select Range to protect and unprotect ranges by [email protected]
I use the following macros to go from Day 1 window to Day 2 window on the same sheet and to enable me to tab only on each "window" which is visable I have...
May 15th, 2009 06:04 AM
by [email protected] Go to last post
2 83
How do I locate a circular formula? by Di
I have a workbook with more than 30 worksheets. Each time I open the workbook I get the alert, "Microsoft Office Excel cannot calculate a formula. There is...
May 15th, 2009 03:47 AM
by Dave Peterson Go to last post
2 81
Creating cell names from cell contents en masse by John
I'm attempting to apply unique cell names for 30,000 individual cells. The cell names are easily propogated in cells, but I'm stuck on how to efficiently...
May 15th, 2009 02:41 AM
by Simon Lloyd[_254_] Go to last post
1 83
Post New Thread


Display Options
Showing threads 11041 to 11060 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 09:29 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.