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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
ignoring text data in a cell when summing values in the same cell by FM
I have entered text in cells along with a numerical value as a note pertainig to the values example, "2 - exist". Is there a way to tell Excell to ignore the...
February 24th, 2010 03:51 AM
by T. Valko Go to last post
2 207
how do you flip a column containing different text in each cell by cybermix
column contains from top to bottom: A,B,C,D,E and i want a column conatining after flip: E,D,C,B,A
February 24th, 2010 03:27 AM
by T. Valko Go to last post
4 285
pivot table by Rohit
Hi i have a pivot table and i have extracted data from another file. Now i want to hide details of those numbers. that is when i double click it gives me...
February 24th, 2010 01:21 AM
by Rohit Go to last post
3 241
vb macro format is wrong by what which is up
I am using Excel 2007. I have a question. I recorded a macro which enters in A1 the value 1 B1 the value 2 C1 the value 3 the code looks like this. Sub...
February 23rd, 2010 11:25 PM
by Dave Peterson Go to last post
5 318
importing text as a URL by mariob[_2_]
hi all, I need to import a csv file where every row has an URL such as .....,http://www.something.something,....,..... When I import it the URL is...
February 23rd, 2010 11:07 PM
by SVanDee[_2_] Go to last post
1 224
Constant required by Ken Poberezny
Hi, I have two sheets 'cost' and 'materials' on which the constants are placed A cell on 'cost' has this formula =C9*materials!D37 I now need to copy this...
February 23rd, 2010 01:55 PM
by Eduardo Go to last post
4 201
transfer data from multiple columns to singlr column by lc85
I have data in form a d g b e h c f i (but larger scale) and I need it in a single...
February 22nd, 2010 10:19 PM
by SVanDee Go to last post
3 239
how to stop data shifting into new cells every time workbook is o. by Jane G
Some of my Data remains the same in my workbook but then columns H- shifts into different cells after I've saved the sheet and then I reopen to work in it...
February 22nd, 2010 08:25 PM
by JLatham Go to last post
1 172
Sum of product by tb
I am trying to find a formula to total a specific product from a list into another worksheet for totals. Can i use a LOOKUP formula to look for that specific...
February 22nd, 2010 07:42 PM
by Eduardo Go to last post
2 167
Excel 2007 won't print spreadsheet by Mac99
New HP computer with Win 7 and MS Office 2007. Printer is Dell V505, and I have installed correct printer driver for Win 7 and the Dell prints everything OK...
February 22nd, 2010 01:29 PM
by JLatham Go to last post
1 225
column heading label by Ron
The column label heading has change from an ABC format, to 123 format just like the row format of 123 rows. I am not sure if I changed this setting how I did...
February 22nd, 2010 06:19 AM
by trip_to_tokyo[_3_] Go to last post
1 213
HOW TO FIND THE MEREGED CELL by Sudhakar A.R
when i sort the serial no excel shows Some merged cell is idintifed how find that hiden mered cell? Submitted via EggHeadCafe - Software Developer Portal of...
February 22nd, 2010 02:31 AM
by SVanDee Go to last post
3 222
Delete worksheets in Office Excell 2007? by Tweety Bird
How can I delete worksheets in Office Excell 2007?
February 21st, 2010 10:17 PM
by Chip Pearson Go to last post
1 185
Making actual projects with Excel 2007 by Ai
I have read several books and so far have basic and general understanding of the mostly use features of Excel 2007. However, I am wondering if there are...
February 21st, 2010 01:23 PM
by Russell Dawson[_2_] Go to last post
1 180
VLOOKUP Range_lookup TRUE by Pekka Numminen
Why don't my tests work? http://img716.imageshack.us/img716/4035/vlookuptest.gif http://img525.imageshack.us/img525/5245/vlookuptest2.gif
February 21st, 2010 11:39 AM
by Per Jessen Go to last post
6 379
Sum and If by Shirl
I am wanting to add numbers in Column B,d,f etc only if it equals the text in Column A,c,e etc -- Shirl, NZ
February 21st, 2010 05:02 AM
by L. Howard Kittle Go to last post
4 216
Column Sorting by trvlnmny
I am using W XP & Excel 2003. I would like to know if there is a way to sort on more than 3 columns? If so how is it done? Thanks for the help.
February 21st, 2010 03:30 AM
by Dave Peterson Go to last post
1 176
OR within Criteria of SUMIF by Pekka Numminen
Is it possible to use the logical function OR within the "Criteria" argument of SUMIF? If so, how?
February 21st, 2010 03:20 AM
by T. Valko Go to last post
2 187
Visual Basics Error - Goto by Shirl
Please help. I keep getting an error from my visual basics code. Click on a button on a sheet takes you to another sheet within the same workbook then...
February 20th, 2010 11:33 PM
by Dave Peterson Go to last post
1 142
how do i use the daye function to insert a serial number by stephanieylalo
how do i use the date function to insert a formula that inserts a serial number for a specific date
February 20th, 2010 05:03 PM
by Gord Dibben Go to last post
2 166
Post New Thread


Display Options
Showing threads 361 to 380 of 13737
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:16 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.