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
PeopleSoft report spits out 1 row into 2 rows -how to make 1 row by Sandyh
Hello My report on row 1 has product number and all the info Row 2 has the description How do I turn this into all one row. Also the report can have 2000 to...
February 21st, 2009 06:24 AM
by Shane Devenshire[_3_] Go to last post
1 64
I need to create a fill in form by tallmankg
I need to create a fill in form for reports IE: ___________ name __________________ Address Thanks Ken Gray
February 21st, 2009 06:16 AM
by Shane Devenshire[_3_] Go to last post
1 78
Parse A String into Two by xlmate
I can't remember how do I separate the text into two by finding the 2nd upeer case. eg SmithJohn to Smith John -- Appreciate your help.
(Multi-page thread 1 2)
February 21st, 2009 04:06 AM
by Ashish Mathur[_2_] Go to last post
11 136
use check box created in Excel 2003 opened in Excel 2007 by TommyB
I have created a worksheet in Excel 2003 that includes check boxes. I have users of that worksheet who are using Excel 2007 who are telling me they cannot...
February 21st, 2009 02:01 AM
by Barb Reinhardt Go to last post
1 76
pick list location by liem
I have a set of data with 10000 row Div Market salesman Factor Result 1599 1501 John sales R 1599 1501 John Profit ...
February 21st, 2009 02:00 AM
by liem Go to last post
3 97
if- then statements by Paul
hi there. i cant figure out how to do an "if - then" type of function. If A1= 23 then B2= Red or, if A1= Blue then B1= Color wheere i have a list of datat...
February 21st, 2009 01:06 AM
by Pete_UK Go to last post
7 64
Extracting row with lagest amount by Steve Walford
Hope someone can help Using Excel 2002 I have a large spread sheet, which details the amount of fuel issued to individual vehicles over a set period...
February 21st, 2009 12:14 AM
by Ashish Mathur[_2_] Go to last post
7 154
How do I retreive the last # in a column? by Claudio
I am trying to substract the value in the first cell in a column from the last value in that column using a function, which i can't find. I want this unknown...
February 21st, 2009 12:00 AM
by Ashish Mathur[_2_] Go to last post
2 83
auto populate different cells when selecting from drop down list. by abitanga
Help, can someone point me in the correct direction for this info! What I am trying to do is program a Excel spreadsheet to auto populate several different...
February 20th, 2009 11:44 PM
by Ashish Mathur[_2_] Go to last post
2 77
drop-down list by karelina
How do I copy a drop down list easily in a column of 600 rows? Dragging doesn't work, copying all the cells and validating doesn't work, fill down doesn't...
February 20th, 2009 10:49 PM
by Gord Dibben Go to last post
2 68
Alphanumeric custom formats by May47
does anyone know how to create a custom format in Excel 2007 that will all you to enter this: 123456B789 and it automatically changes it to...
February 20th, 2009 09:59 PM
by Gord Dibben Go to last post
3 71
Linking Checkboxes/Drop Down Lists to a Formula by Ryan F[_3_]
Hey guys, back with another question. I am currently making a spread sheet to determine what percentage of phones we get back are of the following...
February 20th, 2009 09:45 PM
by Shane Devenshire[_3_] Go to last post
4 91
Need MAX value if condition is met by SCC
I have a spreadsheet that lists usage in our computer lab. From the data I am able to get the average usage for each day using the averageif function...
February 20th, 2009 09:10 PM
by T. Valko Go to last post
4 55
Can selection from text drop-down dictate value in another cell by Relating text to values in drop-downs
I am working in Excel. I have created a text drop-down menu in one column. Can I insert a function so that when a choice is made, a value automatically...
February 20th, 2009 08:50 PM
by Ken[_21_] Go to last post
3 98
Sharing by Bridget
Hello, I'm having trouble making a document viewable to all but one that can only be edited by 2 other people. I went into tools to share the document and I...
February 20th, 2009 08:09 PM
by Bridget Go to last post
2 106
Showing data unigue to multiple columns in a pivot table by lisaB
I have multiple columns of data with over 300 rows. I need to show entries that are unique between two columns. For example if Column A is Regulation, Column...
February 20th, 2009 07:56 PM
by Luke M Go to last post
1 66
printing blank forms with auto generated numbers by Smurrock
This seems like a simple macro function but I cannot figure out how to make it work. I am trying to print inventory forms so I will need a lot of them and...
February 20th, 2009 07:29 PM
by Gord Dibben Go to last post
4 122
2 formulas in 1 cell by MAX
If cell B2B1 answer in A2 must be 0 and if cell B2B1 answer in A2 must be equal to B1
February 20th, 2009 06:56 PM
by MAX Go to last post
5 76
OMG Help! by AbbysMum04
I am not an excel expert so I'm hoping someone reading this might be. I am attempting to create a "Scoring" sheet with pre-set values for criteria. What I...
February 20th, 2009 06:49 PM
by ~L Go to last post
3 60
How do you easily add rows to check register template by mrboard
Had problem carring over formulas in check register template when i add rows to the sheet.
February 20th, 2009 05:53 PM
by Joel Go to last post
1 62
Post New Thread


Display Options
Showing threads 14081 to 14100 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 06:16 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.