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
Fill in Column with a series of repeating numbers by mimi
I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got...
June 5th, 2010 01:42 AM
by David Biddulph Go to last post
2 1,149
Keeping Formulas Not Data by Jenni R
I input my formula, but would like to fill in the data later. How do I save the Formula without there being data. I am trying to create time sheet that will...
June 5th, 2010 01:27 AM
by Gord Dibben Go to last post
1 867
F4 no longer automatically creates absolute reference by molla
I select the text of a cell name (A1, for example), hit F4, an nothing happens. I have to go in and type my $. How do I reset F4 to work?
June 5th, 2010 01:23 AM
by Gord Dibben Go to last post
2 848
Data Labels in Excel Pie Charts by Marlaine
How do I get the data labels to stay where I put them in pie charts. I have a series of pie charts set up and update the data they are based on monthly. I...
June 4th, 2010 11:53 PM
by Marlaine Go to last post
0 890
COUNTA or COUNTIF or COUNT by Liz
Trying to count the times "YES" occurs in column C3:C5 for each time "Bill" indicated in column B3:B5? -- Thanks - liz
June 4th, 2010 11:41 PM
by Don Guillett[_2_] Go to last post
4 823
Formula to pull the lowest supplier name by Cassius
I need assistance creating a formula to extract the supplier name associated with the lowest supplier bid. A sample of the data looks like this. I need to...
June 4th, 2010 11:40 PM
by Don Guillett[_2_] Go to last post
3 902
Lookup values based on column headers? by Doug
I have a data validation dropdown list box in "sheet1" cell $J$1. Depending on what I have selected in that dropdown list I would like it to match or lookup...
June 4th, 2010 11:18 PM
by Doug Go to last post
2 897
Racking my brain on sumif by Victor R.
I have a report download that roughly looks like this: Part # Date Qty 1234 6/1/10 25 1234 6/3/10 50 1234 6/7/10 100 4567 6/1/10 ...
June 4th, 2010 10:48 PM
by Bernd P Go to last post
4 874
vendor matches by John
This is my first question on this site, so I hope I hope this makes sense. I have vendor numbers in Col A-each vendor number would only be listed one time...
June 4th, 2010 10:43 PM
by John Go to last post
6 1,154
Size of file with pivot table by Nadine
I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot...
June 4th, 2010 09:44 PM
by Nadine Go to last post
2 903
iserror and ifs nested formulas by Vicki
Please help! I am trying to get the formula below to return a value to the cell ONLY if the answer to ((c30-$30)/g$30) is greater or less than 20%. I am...
June 4th, 2010 09:34 PM
by Vicki Go to last post
4 815
Looking up next available number by Nadine
I have columns numbered for payments. A PO can have any number of payments. A PO can be shown on any number of rows as the resource being billed against the...
June 4th, 2010 09:34 PM
by Nadine Go to last post
3 853
barecode command by bgs
customize toolbar , all commands, barecode cammand, after barecode command has been placed in toolbar, it has not funtion, i am unable to click on it , under...
June 4th, 2010 09:10 PM
by bgs Go to last post
0 731
Workbook causes calculation errors by Luke M[_4_]
I've never seen this error before, and unfortunately, my Google searches keep bogging me down with the simple "Automatic/Manual" solution... I have Workbook...
June 4th, 2010 07:19 PM
by Luke M[_4_] Go to last post
2 976
Exported data from Banner database to Excel by CBB
When I take a Banner database exported to excel and save it as .dbf file to use in mailing software, it drops certain fields in the name field. Does anyone...
June 4th, 2010 06:29 PM
by CBB Go to last post
0 808
Concatenation help by Nadine
I have 3 cells I need to merge into one. One of the cells is a number anywhere from 1-16 or more. What I need is for the number in this cells to always be...
June 4th, 2010 06:20 PM
by Rick Rothstein[_2_] Go to last post
8 1,025
Counting question by John
In column A I have set of characters that are entered into the rows below (i.e. Y, N, MRO) in column B I have another set of characters that are entered into...
(Multi-page thread 1 2)
June 4th, 2010 05:46 PM
by Ms-Exl-Learner Go to last post
16 1,579
Multiple IF's with an OR by Nadine
Cell DQ contains a formula that pulls in the status of the item. Here is my existing formula so...
June 4th, 2010 05:37 PM
by Ms-Exl-Learner Go to last post
5 913
How to tell COUNTIF to not count a few characters by Rafa
Im working on a colum that is a medical schedule for Doctor who will be working that day so that I know how many exam rooms will be needed - right now Im...
June 4th, 2010 04:40 PM
by Jackpot Go to last post
2 839
Countif Question by John
-- John
June 4th, 2010 04:40 PM
by John Go to last post
0 790
Post New Thread


Display Options
Showing threads 41 to 60 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 07:01 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.