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
(Please Help) Merge coloms based on equal rows with information by khers
Hi I have a sheet with this information Card# Name Surname 1 A Alast 2 B Blast 3 C Clast 4 D ...
August 22nd 11 11:37 AM
by Pete_UK[_8_] Go to last post
1 269
Unable to Insert Worksheets or Change Tab Names by koper
I worked on a workbook yesterday and added a sheet to it. One of my colleagues came in today she said one of her workbooks would not allow her to modify the...
August 21st 11 04:23 PM
by Gord Go to last post
5 1,847
Weird corruption of hyperlinks by Terry Pinnell[_2_]
I'm using Excel 2000. Somehow the hyperlinks I've created, which used to be OK, have now become oddly 'corrupted'. Take an example, an entry for which the text...
August 20th 11 12:22 PM
by Dave Peterson[_2_] Go to last post
7 293
Combining multiple workbooks by Roger Dodger
Hi All, My work platform only allows for 16 searches per file so have to process 2,3 or 4 searches and save them to CSV. We will call them Nit1, Nit2, Nit3...
August 19th 11 07:32 PM
by trip_to_tokyo[_3_] Go to last post
1 206
stopwatch times by Craig
Excel 2007 cell formating - I need to enter stopwatch testing times in minutes and seconds format. I have tried mm:ss and :ss. With both Excel wants to add...
August 18th 11 07:14 PM
by joeu2004[_2_] Go to last post
9 1,346
Columns not sorting properly. by StargateFan
I'm stumped on this one - I had it happen once before but I don't recall the fix. When I sort either manually or programmatically via a recorded script, by...
August 17th 11 06:22 AM
by StargateFan Go to last post
2 376
How to copy a range of cells and paste into a new workbook in differentcolumns by Mas[_4_]
Hi all, I have created a macro that copies and a number of columns and pastes them in a new workbook in a variety of columns but the macro look...
August 16th 11 02:57 PM
by Gord Go to last post
3 293
Line with length depending on the value of the cell by Subodh
Hi All, I want to get a line in a row of cell, lets say from in Row1. And, if the value in A1 is 1 the line should be in Cell B1 ...
August 16th 11 12:05 AM
by Don Guillett[_2_] Go to last post
3 303
Saving as XML by Gavin Bird
Hi, Building a vba module that exports timecard data from XL to a payroll system using an XML import format. Everything is OK except when the created file is...
August 15th 11 04:20 AM
by Gavin Bird Go to last post
0 286
How to lookup based in the first 3 characters of a cell by Mas[_4_]
Hi all, I would like to know how I can perform a lookup formula to lookup a column based on the first three characters of a cell. i.e. Column A - AA1-0001,...
August 14th 11 12:04 PM
by Dave Peterson[_2_] Go to last post
2 1,137
Importing data from Excel worksheet into Excel template by Mas[_3_]
Hi all, I would like advise on how I can import data from an Excel Worksheet into an Excel Template. For example: Excel Workseet Column A : Date Column B :...
August 14th 11 11:15 AM
by Mas[_4_] Go to last post
2 272
Timetable by Jake[_6_]
I have a timetable for a multi day journey train, and I need to calculate the time to each next stop in hh:mm in column G. In column A is the station name,...
August 13th 11 05:17 PM
by Jake[_6_] Go to last post
7 312
Need help with formating cell by Bandit
I have a very simple worksheet with formulas. Here is what I have: ColumnB ColumnC ColumnD Sales Amt Sales Return ...
August 12th 11 06:16 PM
by Vee Sue Go to last post
4 502
Ctrl+Click doesn't select non contiguous cells by Rafeek
When I Ctrl+Click on non-contiguous cells, it doesn't select them. I couldn't find any settings in Excel Options. Please help. Thanks in advance ahmed.
August 12th 11 02:33 PM
by Rafeek Go to last post
0 333
Excel 2007: mouse cant find cell handle to drag/move by Carl Henthorn
I am using Office 2007 sp1, and I find myself not being able to move/drag a cell around inside Excel. Normally I would enter some data in a cell, then find...
August 12th 11 11:13 AM
by sagar aggarwal Go to last post
3 7,493
Formula Quesion by JimS
I have the following formula in cell AR12: {=SUM(INDIRECT("ar"&LARGE((AR14:AR10000<>"")*ROW(14:10000),14)&":ar10000"))} It works exactly as I would like,...
August 11th 11 03:28 PM
by GS[_2_] Go to last post
5 291
Formula to display next Friday from B1 works except on the Friday itself. by StargateFan[_2_]
I found a formula for displaying the next Friday from the user input date in B1. It works great except if the input date is a Friday. I need a spreadsheet...
August 11th 11 09:20 AM
by StargateFan Go to last post
4 415
Copying a range of data without adjusting formulas by Captain Jack Flak
I often have to create several versions of a report that summarizes data in slightly different ways. It is easiest to do this by copying an existing form to...
(Multi-page thread 1 2)
August 11th 11 08:51 AM
by Olivier Beaujean Go to last post
18 1,042
How smart is excel? by Anthony[_5_]
I do roster assignments for a youth flag football league. The league has grown to over 1500 kids so doing team assignments manually has gotten to be a bit of...
August 10th 11 09:46 PM
by Anthony[_5_] Go to last post
0 242
Reversed Array by [email protected]
Hi - I'm trying to use LINEST to create an automated, rolling multiple regression. In otherwords, rather than use the Analysis Toolpak over and over again to...
(Multi-page thread 1 2)
August 9th 11 08:21 PM
by Travis Go to last post
10 846
Post New Thread


Display Options
Showing threads 2001 to 2020 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 02:50 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.