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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Lookup reference help by DubboPete
Hi Folks, I have a sheet, where the contents of cell A1 is a result of other criteria being met. For the purpose of this example, the result in A1 is "Oral...
May 10th, 2010 05:36 AM
by T. Valko Go to last post
3 228
Can I stop the footer from indenting? by Michelle
The footers in my spreadsheet seem to be indented differently from the main spreadsheet margin. Does anyone know a way to get the footers to align to the...
May 10th, 2010 02:17 AM
by JLGWhiz[_2_] Go to last post
4 323
table lookup by dksaluki
Let's say i have a table. I can use MATCH() to know that I want to look in column 13 for a certain value. Now I just need to figure out what row a certain...
May 9th, 2010 08:36 PM
by Lars-Åke Aspelin[_4_] Go to last post
2 279
2003 Keeps the default workbook open by Michelle
When I start Excel, it starts up with a blank workbook. If I immediately open a saved file, it closes the blank workbook... All good... except mine has...
May 9th, 2010 04:13 PM
by Bob Ryan Go to last post
1 232
Searching from one list in another by Brian[_12_]
I have a workbook which has one tab (“Shortlist”) with about 150 rows of data, and a tab (“Longlist”) with about 20,000 rows of data. I need to be able to...
May 9th, 2010 01:14 PM
by Dave Peterson Go to last post
3 286
excel separation by Kevin
Question Here is a problem I have: 123456789 134567890 135678901 1456789012 157890123 this group of numbers is in my Sheet and each line is in a row by...
May 9th, 2010 02:59 AM
by Gord Dibben Go to last post
1 245
Countifs and date comparison by KennyD
Okay, trying to figure one out here (although Dave Peterson could probably do it in his sleep :D). I have two sheets, Sheet_2 and dB_File. I want to use an...
May 8th, 2010 07:32 PM
by Bernard Liengme Go to last post
3 274
compare 2 columns and select the lowest by Delya
Hi I have simple question I have 2 coumns A and B A1 is text and B1 is numbers and so on.. depending of B columns numbers , i want colums C to show alway...
May 8th, 2010 07:07 PM
by excelent Go to last post
2 276
date by Rubem
Hi, I have a table if several columns. One of them is Invoice Date. I am using Pivot Table to compile the data. I am trying to find out how many invoices...
May 8th, 2010 06:35 PM
by trip_to_tokyo[_3_] Go to last post
2 207
FIND ERROR PROBLEM by Dan
hi, I have pieces of formula's that might help to figure out how to find where an error is located (by column & row). thanks in advance. examples include: a...
May 8th, 2010 06:20 PM
by Dan Go to last post
0 188
lookup for the minimum date among different dates by khaled shaheen
Hi all, I badly need your help in the below formula Example: Structure : Account includes Sub-accounts and each sub-account includes dials Formula : Account...
May 8th, 2010 05:35 PM
by khaled shaheen Go to last post
3 257
SUMPRODUCT by Tmt
Hello, I've used this formular to find work piece that gets done per department. =SUMPRODUCT(('Q2'!E13:E150="Done")*('Q2'!G13:G150="14532")) Department 14532...
May 8th, 2010 01:12 PM
by Don Guillett[_2_] Go to last post
3 249
Automatic display positive or negative by tran1728
Dear All, pls help me. when I type $ 52.00 on C1, I want C1 display positive $52 or negative ($ 52) , if B1 is positive or negative, I want the entire column...
May 8th, 2010 11:34 AM
by tran1728 Go to last post
3 232
I would like to extract email addresses from an Excel document by ladyblue214
I have a spreadsheet of names and addresses. I would like to extract the email addresses to put in an email to send out to all. Can this be done
May 8th, 2010 10:40 AM
by ozgrid.com Go to last post
1 270
validation by ganga
hi, I have a workbook with 2 sheets. In one sheet I have a calender and other sheet just list of names. what i want to do is: In the calender sheet if i...
May 8th, 2010 07:31 AM
by Kristiina via OfficeKB.com Go to last post
3 206
Movement of the cursor by tran1728
Dear All, i need your help pls, This is really basic but I could not find a thread. I want to control the movement of the cursor. move direct at A6 after...
May 8th, 2010 05:28 AM
by tran1728 Go to last post
4 253
logitech mouse wheel in Excel zooming rather than scrolling by jukebox
when in excel 2007, using scrollwheel on wireless logitech mouse activates zoom in & out rather than scrolling up and down a spreadsheet. i'm sure i have...
May 8th, 2010 05:03 AM
by FSt1 Go to last post
1 275
Excel 2007 Selection Tool Broken? by Quin
I am using Excel 2003 at work and Excel 2007 at home. I have a file that uses hundreds of text boxes and images. At work, using Excel 2003 I can use the...
May 8th, 2010 04:53 AM
by Quin Go to last post
0 230
Command Button by WLMPilot
I am unable to locate the section I need to add a commandbutton to excel worksheet. Where can I find this at? Thanks, Les
May 8th, 2010 04:52 AM
by trip_to_tokyo[_3_] Go to last post
1 302
Missing question by khaled shaheen
Dears, How can i find my question that i have sent to you but unfortunately can't remember the question's subject? and also i haven't received replies in my...
May 8th, 2010 04:03 AM
by FSt1 Go to last post
1 258
Post New Thread


Display Options
Showing threads 1161 to 1180 of 139764
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 11:35 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.