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
how can i transfer data from one sheet to another without blank li by Manos
Dear All I have extracted data from a system to a sheet including blank lines between the data. Any idea of how i can transfer the data from one sheet to...
April 23rd, 2010 10:54 AM
by Jacob Skaria Go to last post
1 126
GETPIVOTDATA and (blank) by Tige Brown
I have created a spreadsheet which has two pivot tables in it on separate sheets. In addition there is a summary sheet which I use the GETPIVOTDATA function...
April 23rd, 2010 01:46 AM
by Tige Brown Go to last post
0 129
Keep lines when one column equals certain criteria by Donna[_5_]
Thanks for taking a look at this one. I have a worksheet with invoice amounts, payments, voids and adjustments each on a separate line. Each line has an...
April 23rd, 2010 01:16 AM
by Donna[_5_] Go to last post
2 143
IF and Right Functions by Elaine
Hello, I have part #'s that end in 3 or 4 characters, some with a space. I would like to display the last 3 or 4 characters in another column. I tried using...
April 23rd, 2010 12:34 AM
by Elaine Go to last post
9 296
why this strange result with vlookup by Amin
hi i have this formula in a cell =VLOOKUP(A3,'LookUp Data'!A2:O740,2,FALSE) but any time i pick a code from my list items in column A it gives #NA but as soon...
April 23rd, 2010 12:16 AM
by Max Go to last post
3 189
Copying Cells with Fill Handle by RRG
Can anyone help? I am trying to copy cells across a row using the fill handle that are referencing another sheet down a column. I am placing a "$" in front...
April 23rd, 2010 12:12 AM
by Gord Dibben Go to last post
3 161
Categorizing Data Question by Demosthenes
Hello, I have a list of data in C, and would like to create a column in D that organizes that data into a specific category. For example, given: Fruit ...
April 22nd, 2010 11:48 PM
by Pete_UK Go to last post
4 157
background colour of sheet gone gray need to change to whit by Change Background colour of worksheet
On jst one sheet in my book of several sheets the background has turned gray. I copied it and it was still gray. How do I change it back to white.
April 22nd, 2010 11:08 PM
by CLR Go to last post
1 233
Conditional Formatting in Excel 2007 by kvollmer
I have probably 30 conditional formats built in one file, but when I "saved as" to another name to create another file, only a few of the conditional formats...
April 22nd, 2010 10:20 PM
by Niek Otten Go to last post
1 162
"#VALUE!" Cell Value by DisMusBeDaPlaz
Some of my cells are turning up the value "#VALUE!" in the cells. I have duplicated the problem that I am having. A test worksheet. I am using data in one...
April 22nd, 2010 10:11 PM
by Niek Otten Go to last post
1 164
How do I use sumifs - by wantfit
I want to use sumifs to find the results. For range A1:A100, If value in column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do I do...
April 22nd, 2010 09:37 PM
by Teethless mama Go to last post
1 159
Counting by color by Danny Boy
I saw this formula on Chip Pearson's site. According to Chip: You can use the ColorIndexOfRange function to get the sum of the values in those cells whose...
April 22nd, 2010 09:28 PM
by Gord Dibben Go to last post
3 166
Grouping on protected worksheets by wnwilkerson
I want to protect the cells in my worksheet, but when I do I am no longer able to collapse or expand grouped items (rows/columns). Any ideas on how to...
April 22nd, 2010 09:15 PM
by Gord Dibben Go to last post
4 187
Excel - How to get tab to go to next unlocked cell across columns by Linda
Is there any way to use Excel as a form for data entry and have the enter and/or tab key take you to the next cell for data entry when the next cell. ...
April 22nd, 2010 09:12 PM
by Gord Dibben Go to last post
3 306
xlbgnm in remote data by Bill Johnson
I have an xls (2003) excel spread sheet that calls data from another application (DDE) like this: =RSLINX|'PC2'!'ANA' and like this =Rslinx|'EC2'!ACT01 This...
April 22nd, 2010 08:21 PM
by Aurelie Bonvillian Go to last post
1 582
Conditional Formula Words by Fab
Okay here we go. I need to create a Conditional Formula that 1. Identifies the words i.e. Single Adult or Single Adult + 1 Child and then returns the number...
April 22nd, 2010 07:57 PM
by JLatham Go to last post
4 173
looking for a function that will populate opening a worksheet or t by Olivia
I need some help to see if Excel will be able to accommodate a task I would like to do. I have this tax payment worksheet in excel, what I would like to...
April 22nd, 2010 07:38 PM
by Olivia Go to last post
2 175
multiple IF calculations by mel
I've figured out how to make cell X display the number of hours entered into D9 if the text "Stat Worked" appears in D11, but now I need to do the same for...
April 22nd, 2010 07:18 PM
by mel Go to last post
6 134
Default Cell value in changing environment by TheDrescher
I don't know if this is possible to do, but I figured I'd ask. I have a workbook where the first worksheet populates data on employees based on their name...
April 22nd, 2010 06:41 PM
by Luke M[_4_] Go to last post
3 157
When refreshed, some Pivot Table columns retain formatting, some d by Josel
I have not had trouble with retaining column widths and column heading formats (font size, word wrap, alignment) in Pivot Tabl. When refreshed, they retain...
April 22nd, 2010 05:50 PM
by Josel Go to last post
0 173
Post New Thread

Display Options
Showing threads 1061 to 1080 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 01:57 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.