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
Regressions p-value is #NUM! whats wrong by ShriHanuman
I have a Data set as: Data C1 C2 C3 0.2481 1 0 0 0.9231 1 0 0 1.0361 1 0 0 0.7399 1 0 0 0.9579 1 0 0 0.8665 1 0 0 0.9891 1 0 0 0.9817 1 0 0
July 14th 16 08:01 PM
by ShriHanuman Go to last post
0 280
How to I reset a forgotten Excel worksheet protection password? by tomprochaska
We are using an Excel Workbook containing a password protected worksheet. No one knows how, but the password to unprotect the worksheet was changed. Is there...
(Multi-page thread 1 2)
July 11th 16 08:54 AM
by Flametucan Go to last post
10 19,449
Twinning Cells by SimpleChris
Hi, I have this code for 'twinning cells' which I found on an old post in here from 2009.... Private Sub Worksheet_Change(ByVal Target As...
July 8th 16 08:37 AM
by SimpleChris Go to last post
0 304
Trying to install on Windows10 PC by Terry Pinnell[_4_]
A bit OT, sorry, but I'd greatly appreciate some feedback please. I'm in my second week on a new PC with Windows 10 after 15 years of XP. (Quite daunting!)...
July 6th 16 05:23 PM
by Claus Busch Go to last post
1 276
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 287
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 406
Exclamation
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 361
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 561
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 404
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,426
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 578
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,755
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 561
Cool
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 528
Print titles must be contiguous and complete rows or columns by [email protected]
Thank you so much.
0 450
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 932
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 1,974
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 585
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 442
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 529
Post New Thread


Display Options
Showing threads 101 to 120 of 146423
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 01:47 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.