A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
IF (formula is true) put a "1" in another cell by Sandta
How do you put a value in another cell if the formula you are using is true. =if(A1>=3000,"(put a 1 in B1)",otherwise false)
June 26th 09 04:39 PM
by T. Valko Go to last post
2 275
how do I separate last, first names from 1 column into 2 columns? by SDoc
Example: Doe, John (in 1 column) to Doe John in separate coumns. Thanks!
June 26th 09 04:29 PM
by willwonka Go to last post
3 557
Excel 2007 Shortcut Keys (Y01 - Y18) by willwonka
Hi, I am new to Excel 2007 and learning the new shortcut keys. I am using an addin so once I hit the Alt key, the "x" key to get to the Addin Ribbon, the...
June 26th 09 04:28 PM
by willwonka Go to last post
1 425
why do i get a #ref by Zab
hello...
June 26th 09 04:18 PM
by T. Valko Go to last post
4 329
Conditional formatting, Excel 2007 by Horatio J. Bilge, Jr.
I am trying to copy conditional formatting in Excel 2007, but it doesn't seem to work the same way that I remember in 2003. Or maybe I'm doing something...
June 26th 09 04:16 PM
by Horatio J. Bilge, Jr. Go to last post
2 430
Complex IF Statement by Jonni
I am trying to write a formula charging the first 400 tickets $5 each. But as soon as the 401st is sold, I need it to be $8. Tickets are not being sold one...
June 26th 09 04:09 PM
by Brad Go to last post
7 648
xlsx won't open with compatibility pack by MKG
Windows XP, Office 2003 sp3, Compatibility Pack. We have one user who is unable to open xlsx files even though the compatibility pack is installed. She...
June 26th 09 04:04 PM
by MKG Go to last post
0 2,310
Invalid web query Excel 2007 by Bob
I am running Vista , IE8, and Excel 2007 (all fully updated). Yesterday I ran around 50 web queries and they all worked correctly pulling data from...
June 26th 09 03:51 PM
by Bob Go to last post
0 1,324
Increase font size in Drop-Down List by RidgeView
In many of my worksheets where I have drop-down lists, I need to increase the font size of the list items without having to zoom increase the worksheet size....
June 26th 09 03:48 PM
by JLatham Go to last post
1 1,642
Rank in Pivot Table by KrispyData
I created a pivot table that shows sales by customer by month. I grouped the months into quarters. Now, I would like to rank the customers by sales for...
June 26th 09 03:40 PM
by Atif Go to last post
4 1,012
Odd Formula copying Behavior by PatK
I have a very odd situation going on with excel 2007, and thought I would try a post here, before I try a total Office re-install: I have an excel...
June 26th 09 03:35 PM
by PatK Go to last post
3 487
VLOOKUP in a RANGE. by SAM
Would really appreciate any ideas... I have a range of data A1:M20 containing a number of different percentages. I want to look up the max and min and get it...
June 26th 09 03:25 PM
by SAM Go to last post
9 476
Count Cells where text may contain a specific word by Vic
I need to count (text or general) cells G2 thru G2000 if the text contains the following word DSMB - combination of 4 charachters All Caps. How do I do this?...
June 26th 09 03:20 PM
by Mike H Go to last post
5 1,801
Formula to auto-populate with current date by Bill-Ace
What is the formula to auto-populate a cell with the current date (don't need the time, just the date). Thanks in advance for you assistance.
June 26th 09 02:58 PM
by Mike H Go to last post
1 4,979
Concatenate formula needs a fix by Vic
I am applying the following formula to concatenate 2 counters, one from this sheet and another one from another sheet. This formula is not working. Can...
June 26th 09 02:08 PM
by Mike H Go to last post
7 410
MACRO 2 COPY UNIQUES TO NEW SHEET by Don Guillett
OR Sub MakeUniqueandcopytoothersheet1() With Range("A1:a14") ..AdvancedFilter Action:= _ xlFilterInPlace, Unique:=True ..Copy...
June 26th 09 02:07 PM
by Don Guillett Go to last post
0 279
MACRO 2 COPY UNIQUES TO NEW SHEET by Faraz A. Qureshi
Could one devise a macro to copy only uniques from a specific column(s) of the "Selected" sheets to a new sheet? Because copying them all together on a new...
June 26th 09 01:59 PM
by Don Guillett Go to last post
5 665
Doing multiple borders by Herb[_2_]
How to "freeze" border menu so I can do multiple borders without losing menu each time. I think it was in 2003 Excel that by double clicking title at top of...
June 26th 09 01:52 PM
by Homey Go to last post
1 531
referencing only rows with data by Rich S.
i'm new to macros(cursor only), and i want it to create and print a graph for each row of data(about 25 columns wide). If I select the first row, how can i...
June 26th 09 01:42 PM
by Rich S. Go to last post
2 317
How do I resize a checkbox? by Nick C
I want a checkbox in Excel 2003 and am using ActiveX control checkbox function but can not make it big enough to see, What can I do?
June 26th 09 12:38 PM
by Dave Peterson Go to last post
1 800
Post New Thread


Display Options
Showing threads 20001 to 20020 of 146476
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 On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:13 AM.


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