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(ISERROR(VLOOKUP help required by dgenty
Hi I am trying to Get a IFERROR translated so it works with office 1997. I heard this can be done with IF(ISERROR but I cant get it to work. Below is the...
July 6th 16 03:12 PM
by Claus Busch Go to last post
1 350
delete all rows EXCEPT rows with highlighted cells by [email protected]
Hi all, I have a massive spreadsheet - over 38,000 lines. Some lines have highlighted cells, some don't (the highlights are errors in the data that I have...
June 22nd 16 08:12 PM
by Claus Busch Go to last post
1 480
VBA code to split text data from a cell into multiple cells/rows by alicedb
Hello All, I need your help with a VBA code which should split the wrapped text from a cell, into multiple cells / rows. It can be based on a carriage return...
June 22nd 16 05:05 PM
by Claus Busch Go to last post
1 437
Using AND and OR together by chrisparker3268
Hello, I am having issues executing the following properly: I have a form that will be filled out by an assessor. If checkbox in D5 is checked (which...
June 20th 16 11:10 PM
by Claus Busch Go to last post
3 656
Deleting every other row by [email protected]
Alan Beban, I tried to use your script, but when trying to save it, I receive the error-message: Missing ; before statement. (line 3, file "Code") Code: ...
June 20th 16 06:33 PM
by Claus Busch Go to last post
6 493
Too many levels in the IF function? by trexcel
I am trying to create an IF formula that I can later paste into data validation. However to keep this question simple at first, I will ask it this way. Try...
(Multi-page thread 1 2)
15 3,586
summing a table based on a cell reference? by Dave H
I am pretty sure I could find the answer if I knew how to ask the question correctly but I can't seem to find it. This works =SUM(Table1,]) what I want to...
June 13th 16 03:21 PM
by Dave H Go to last post
0 680
Military Time in Excel by John Smith[_7_]
I would like to create a timetable in Excel with the format in the 24 hour clock without the colon, which I believe is known as military time. I am leaving...
7 1,877
Disappearing Curves ? by Bob[_19_]
Hello, Always something, I guess. Will blame it on my age, now. Undoubtedly did something "dumb," but cannot imagine what. Using Excel 2007 and W10. Have a...
June 10th 16 11:15 PM
by Bob[_19_] Go to last post
0 656
2 Attachment(s) Transfer data to cell location defined by row and column text headers?? by rob100989
Hi! I need to transfer a series of single cell values from one excel sheet to be stored in another (easy, i know!). However, as the data in the sheet in which...
June 8th 16 12:31 PM
by rob100989 Go to last post
0 621
Print titles must be contiguous and complete rows or columns by [email protected]
Thank you so much.
0 550
Trapped in a cell! by [email protected]
On Wednesday, October 23, 2002 at 11:22:07 AM UTC+4, Jeff Mathews wrote: > Hello Hudan. > > Press Escape. This should abort your changes. > > Jeff Mathews,...
1 1,034
2007 Pivot Tbl to Access Conversion Issues by LindaSD
I have a large number of 2003 Excel Pivot Tables that connect via odbc to 2003 Access queries. I recently converted one database to 2007. I then converted...
4 2,083
Excel 2010 by UrdialesToliUrdiales
When trying to open Excel 2010 file "Excel cannot complete this task with available resources. Choose less data or close other applications." Anyone else...
May 31st 16 12:19 AM
by SaraivaPetronio0 Go to last post
2 698
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, 17 June 2010 09:50:35 UTC+5:30, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error : in...
0 549
Macro organisation? by Terry Pinnell[_4_]
Many years ago I wrote quite a few Excel macros using 'XLM Macros'. After some googling today I understand that there's no simple way to convert these...
May 29th 16 06:38 PM
by Terry Pinnell[_4_] Go to last post
4 628
Delete cells based on condition by Terry Pinnell[_4_]
I've been struggling with this for a couple of hours and would much appreciate some help before I give up please! I want to delete a cell in col A if it is...
May 27th 16 07:28 PM
by Claus Busch Go to last post
6 869
Conditional row height? by Terry Pinnell[_4_]
In Excel 2000 I read "For Conditional Formatting you can set Font Style, Underline, Color, and Strikethrough." Is there any way to adjust Row Height...
May 27th 16 12:18 PM
by Terry Pinnell[_4_] Go to last post
5 1,069
Dynamic + Fixed worksheet name by michaelberrier
I want to name a worksheet with a fixed name, say "Total" and a dynamic cell value which will be a number. So, if the cell reference is A1, and the value of A1...
May 25th 16 11:12 PM
by michaelberrier Go to last post
8 868
Insert - Hyperlink - Recent Files - (How is this list populated) by [email protected]
I often insert hyperlinks into excel documents. It can be a bit of a pain to navigate to the specific files when setting up the hyperlink. However, often I...
0 710
Post New Thread

Display Options
Showing threads 121 to 140 of 146435
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 12:36 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.