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
toolbar "button" for hiding/unhiding sheets by Barb in MD
I know I can create toolbar " buttons" to hide & unhide sheets by selecting "add/remove buttons" and then customize, and then clicking on format, sheet,...
February 10th, 2010 02:45 AM
by Barb in MD Go to last post
2 108
vba to delete rows by ericahughes
Can anyone help me to write a vba to delete rows that have the word lab in Column G? I would like to include nonptlab or labuseonly as well. Basically...
February 10th, 2010 12:27 AM
by Ashish Mathur[_2_] Go to last post
1 160
Convert number to text by Brookyboy
I have a cell with a number in it 1-10 I want to convert that to text like person1 - person10. I have tried all sorts of formula but not quite got there...
February 9th, 2010 11:20 PM
by L. Howard Kittle Go to last post
3 96
maximum nested IFs by Opal[_3_]
Help.... I understand that Excel only allows for 7 nested IF statements.... I have 7, but the following responds with #VALUE! for the last 2 items in my...
February 9th, 2010 11:20 PM
by T. Valko Go to last post
6 163
Macro to delete any control box and pictures by Steve
I recorded this macro: ActiveSheet.Shapes("Control 3").Select Selection.Cut ActiveSheet.Shapes("Picture 1").Select Selection.Cut ...
February 9th, 2010 10:46 PM
by Steve Go to last post
2 97
Help with an array and SUMPRODUCT by xlcharlie
I am not positive that SUMPRODUCT is the right function to accomplish what I am trying to do so I’ll start by describing my objective. I suspect the...
February 9th, 2010 10:16 PM
by T. Valko Go to last post
3 133
VBA to count colored cells by ericahughes
I have never used a VBA, but I am a really quick learner and a self taught excel user. What I have is a conditional format that highlights the row in blue...
February 9th, 2010 09:55 PM
by FSt1 Go to last post
1 144
Getting a formula to do the following: by Pierre
Hi there, I need a bit of a hand writing a formula. I have a column of numbers that has duplicates and triplicates in it; I'm trying to concatenate the data...
February 9th, 2010 08:48 PM
by Pierre Go to last post
2 97
How can I? by DaveMoore
I have a list of 32 numbers ranging from 166.80 to 4,231.22 in cells R1:R32; there may be duplicates but there are no negatives and all are to 2 decimal...
February 9th, 2010 08:46 PM
by Mike Middleton Go to last post
4 158
Looking up any match, returning data by Stacie2410
I've got a spreadsheet that has over 1700 rows of data. The data has columns for: Property # (col A) Production Period (col C) Status (col F) There are...
February 9th, 2010 08:28 PM
by Stacie2410 Go to last post
5 98
Adding totals in columns by Tanya
I have a worksheet that we have hidden rows in. I want to find the sum of a column without picking up the hidden row values? I can I get a sum without...
February 9th, 2010 07:56 PM
by Eduardo Go to last post
2 110
Retaining conditonal formats by MM
Hi, I need some help please! I've designed a sheet to collect data from users which has been set up with lots of set formats (e.g round £ to two decimal...
February 9th, 2010 07:04 PM
by Gord Dibben Go to last post
4 153
Inconsistance Formula? by Tmt
I used this formula to calculate the number of items being serviced in any particular department from another worksheet. It counts most of my data but leave...
February 9th, 2010 07:01 PM
by Fred Smith[_4_] Go to last post
2 103
if statement by Debra Reid
In using the "if" statement I would like the logic portion to state that if cell# = v or m or d or a but the if statement seems to only work if the logic is...
February 9th, 2010 05:52 PM
by T. Valko Go to last post
5 72
If Function?? by Dave Tee
Hello Forum, Excuse me for asking the same question. I submitted on the Excel 2010 forum in error. I have several columns of data. I need to ensure that a...
February 9th, 2010 05:49 PM
by Gary''s Student Go to last post
1 73
Running Total by DisMusBeDaPlaz
Hello Group Excel, I am using Excel 2003. My computation Columns are "E" to "J", and starts on Row 15. Column "I" is the Total. Column "J" is the Running...
February 9th, 2010 05:48 PM
by Luke M Go to last post
3 97
Auto Populating & Name Recognition between Worksheets by Leigh Anne[_2_]
I have a very large worksheet with alot of information and need some help! I want to create a seperate sheets which allow the name to be recognized in the...
February 9th, 2010 05:42 PM
by Luke M Go to last post
1 102
Count with multiple criteria in multiple cells by Mike H
Try this =SUMPRODUCT((D2:D3565="0 Paper")*(F2:F3565=1)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the...
February 9th, 2010 05:02 PM
by Mike H Go to last post
1 72
copying data by Copying data errors
Getting errors when copying data from workbook to workbook. Shutdown and restart allows without errors.
February 9th, 2010 04:18 PM
by Copying data errors Go to last post
0 74
Formula for each # of dollar amount due + how many digits by Olivia
I need some help creating a function or formula in Excel for the following: • Example: payment amount is $2,589.32 Run a tape: 2+5+8+9+3+2 +...
February 9th, 2010 03:36 PM
by Glenn[_6_] Go to last post
7 193
Post New Thread


Display Options
Showing threads 3101 to 3120 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:45 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.