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
Help - I've tried all kinds of things but no luck. by slfwalsh
Howdy, Thanks for taking the time to read my post. I'm having problems creating a custom function in VBA (I'm not an experienced user) Basically i have a...
May 21st, 2010 07:09 PM
by Jason[_11_] Go to last post
1 160
Badly need help with a function by slfwalsh
How do i create a function to give me the following mathematical formula: (a+b+c+d+e+f)/N * 6/N Where a-f are numbers between 0-9 inclusive and importantly N...
May 21st, 2010 05:56 PM
by Don Guillett[_2_] Go to last post
4 183
Data Validation by Lost Cluster
I have a drop down with data validation and I’m trying to compare names from two name ranges. The first name range is called NameCheck, it has the names...
May 21st, 2010 04:20 PM
by Tom-S[_2_] Go to last post
1 207
Reminder - Microsoft Responds to the Evolution of Community by [email protected]
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...
May 21st, 2010 04:17 PM
by T. Valko Go to last post
6 381
May 21st, 2010 03:56 PM
by venus Go to last post
0 235
Average a column that contains one cell of text by Malcolm
What formula do I use to average a column of numbers that contain one cell with text? I'm using Excel 2007
May 21st, 2010 02:55 PM
by Gary''s Student Go to last post
3 190
Average columns that contain text by Malcolm
What formula can I use to average a column of numbers that has one cell containing text?
May 21st, 2010 02:31 PM
by Jacob Skaria Go to last post
2 172
Formulas That Reference ADJACENT Sheet by mlman
I am creating a form in Excel 2003 where I need the formulas in the sheet to reference the adjacent sheet. i.e. I have 3 sheets called 'May 19', 'May 18' &...
May 21st, 2010 01:52 PM
by mlman Go to last post
4 308
Filter by formula by Michel
Hi max Thks for your help but I tried it today but it don't work. In fact I have two workbooks. One is the database file with a list of informations I have...
May 21st, 2010 11:46 AM
by Steve Dunn Go to last post
1 196
WHEN I TOTAL A COLUMN I GET A RESULT IN WRONG FORMAT by cannotgeitright
I am working on sheet 2 and when i try to get the total i get what looks like a date instead of total. I have tried copying the group to another sheet and it...
May 21st, 2010 10:41 AM
by Jacob Skaria Go to last post
2 170
Summing multi-level bill of material by Nathan356
All, I have a multi-level bill of material and I want to create a function that will sum it properly without having to sum up each level manually. Here is...
May 21st, 2010 08:00 AM
by Steve Dunn Go to last post
5 153
converting db need six digit w leading zeros, by eStreet4ever
I need to have a six digit value for an ID field. Old db has values ranging from one to four characters and need to front fill with zeros
May 21st, 2010 05:51 AM
by Jacob Skaria Go to last post
2 166
HELP!! How to formula the "sheet" link by hsfnwa
Hi , I have a workbook contains 1+50 worksheet, I want to link each sheet number to sheet one, besides manually change the sheet # in the formula...
May 21st, 2010 12:23 AM
by Max Go to last post
2 212
Sorting Worksheets in a workbook by Doehead
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I am not sure -- do I have to copy and save it into every worksheet? My workbook...
May 21st, 2010 12:20 AM
by Chip Pearson Go to last post
5 292
VLOOKUP and IF formula by casdaq
I have this formula already in use... =VLOOKUP(B17,'Pivot'!$A$2:$C$291,2,FALSE) I need it to include an "If" formula as well returning a "-" dash if it...
May 20th, 2010 11:46 PM
by Dave Peterson Go to last post
1 185
Count the words in a cell by Elton Law[_2_]
Dear exper A cell contains a lot of information. Is it possible to count certan word in a cell please? Say A1 contains a series of text .... 1. Daily Swing...
May 20th, 2010 09:54 PM
by T. Valko Go to last post
8 229
Ref in two worksheets by wm
I have a bank statement on a worksheet and want to show the current balance in another workbook. I can copy a link for the current balance to the other...
May 20th, 2010 09:35 PM
by T. Valko Go to last post
5 227
counting the occurrence of specific text within a date range by John
In a sheet I have activities completed by specific staff on specific date. I want to countthe number of times the activity occurs within each month (a date...
May 20th, 2010 09:32 PM
by Dave Peterson Go to last post
4 382
SUMIF division by bob
From Sheet 2, I'd like a formula to calculate the following using an array: If Sheet1 Column A = Sheet2 Column A AND If Sheet1 Column K 0 THEN Divide Sheet1...
May 20th, 2010 08:51 PM
by Luke M[_4_] Go to last post
2 210
Totaling text cells by Malcolm
Is it possible to autosum the total of cells that contain only text, in a worksheet that contains cells with only text and cells with only numbers?
May 20th, 2010 06:21 PM
by Gord Dibben Go to last post
2 173
Post New Thread


Display Options
Showing threads 401 to 420 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:53 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.