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
HOW TO COUNT CAPITAL LETTERS IN DATA? by arun sharma
i hv data in which some cells are n full capital letters, some are in small and some are proper, i want to see which cells are in upper case.
June 26th 09 09:12 AM
by Mike H Go to last post
1 1,312
UDF FOR DEPENDENTS by Faraz A. Qureshi
I sure am in a need of a formula to list the address(es) of dependent(s) relevant to a specific cell, existing in the currently opened workbooks so as to...
June 26th 09 05:02 AM
by Faraz A. Qureshi Go to last post
0 316
getting the min and max of a list of numbers by dal_101
I need to get the maximum and minimum values in a list of numbers, some of the cells have 0 (suppressed), and I do not want to include those, and not get the...
June 26th 09 03:24 AM
by T. Valko Go to last post
9 419
output row number for corresponding non-zero value of match functi by lkd
Hello, I have a list of items as shown below: A .5 B B .25 B .25 C C 1
June 26th 09 02:53 AM
by Jacob Skaria Go to last post
2 896
Index by Need_Help
I'm working with two worksheets. Worksheet1, in column A I have years that i use a filter on. What I want to be able to do is after I filter on the years in...
June 26th 09 02:28 AM
by T. Valko Go to last post
4 239
Sum if formula using multiple criteria by Jeremy
I am trying to create a sum if formula that takes the given in Rows B and places them in D given the Criteria in C matches that of A under the Payable,...
June 26th 09 01:35 AM
by Max Go to last post
4 333
Filtering unique combinations of cells by John T Kennedy[_2_]
I have a spreadhseet (10K+ rows) that contains Column D: First Name Coulmn E: Last Name Column F: Company Name How can I setup a filter to show only each...
June 26th 09 12:59 AM
by Max Go to last post
7 4,269
Formula needed. by FC
A B 1 car 90 2 boat 20 3 airp 22 4 car 10 5 boat 25 I'm needing a formula that will add numbers in B related to the item in A...
June 26th 09 12:51 AM
by westy Go to last post
9 402
Formulas not auto updating by Steve
I can't get any of my formulas to auto update in Excel 2007. What am I doing wrong? The formulas are entered in properly but they don't auto update. Also,...
June 26th 09 12:30 AM
by Gord Dibben Go to last post
4 2,834
Globally change an Access connection string by PJFry
I am trying to establish a UAT environment for my staff to test excel reports. These files have a number of embedded queries that use this connection...
June 26th 09 12:25 AM
by PJFry Go to last post
0 565
Trying to import a WR1 file into excel without much luck..clues? by Roget
Trying to import a WR1 file into excel without much luck..clues?
June 25th 09 11:47 PM
by Victor Delta[_2_] Go to last post
1 1,172
Using activecell in vlookup by csdjj
Hi, I want to create a vlookup statement (just in Excel; not via a macro) but I want the vlookup value to be whatever cell the user has selected (I think...
June 25th 09 11:31 PM
by csdjj Go to last post
2 429
numbers by Flya172
is there a way to set up a group of numbers and then of that group of numbers get excel to figure which ones will give a total sum when asked? such ...
June 25th 09 11:31 PM
by Gary''s Student Go to last post
1 274
Converting Lat/Lon coordinates to Decimal by Cheese
I have an Excel spreadsheet with Lat/Lon coordinates in an unusual format. The Degrees, Minutes, Seconds are merged together as text, without spaces. ...
June 25th 09 11:12 PM
by Bernard Liengme[_3_] Go to last post
4 1,632
2 DATA VALIDATION AT SAME CELL by XLFanatico
I have cells with data validation in column A set to range like this: DV> list > =item "item"will be the list that will drop down. I don't want to repeat this...
June 25th 09 11:02 PM
by XLFanatico Go to last post
2 377
Add-in functions by dbustell
I have an Excel Add-in connected to plant equipment on a machine running Excel 2003. When I open the spreadsheet with Excel 2003 on a machine that does NOT...
June 25th 09 10:15 PM
by dbustell Go to last post
6 297
VLookUp or other function to return matched data from multiple col by MMangen
I have raw data that I put into a spreadsheet that I need to match to a pre-existing "legend". Legend Set-Up: Column A - Storefront Name Column B -...
(Multi-page thread 1 2)
June 25th 09 09:44 PM
by NBVC[_44_] Go to last post
12 692
Opening an embedded object in Excel 2007 by Barbara B
In Excel 2003 I would embed a pdf file in a worksheet and when double clicking , it would open the file in Adobe to view all pages of the document. In Excel...
June 25th 09 09:35 PM
by Barbara B Go to last post
0 1,522
Deleting extra rows in Excel 07 by Nat
I know there is an easier way to do this as opposed to manually deleting the extra rows, but here is my situation. We have a large table, which for some...
June 25th 09 09:30 PM
by Nat Go to last post
2 302
Trouble Pasting by RNorfolk
I have an example that best shows what I am trying to do. If you go to http://www.ssa.gov/OACT/STATS/table4c6.html and select part of the table and paste...
(Multi-page thread 1 2)
June 25th 09 09:29 PM
by Dave Peterson Go to last post
10 493
Post New Thread


Display Options
Showing threads 20001 to 20020 of 146451
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:42 PM.


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