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
Help with charting by Excel Dumbo
Dear Friends, I am basic learner in charting. I have a file which involves multiple (more than 2) variables I would like to compare using charts Could you...
August 16th 16 02:20 AM
by Excel Dumbo Go to last post
2 508
email hyperlink - cell value in subject line by boustrophedon
I want to make an email hyperlink that includes text and a cell value in the subject line, like this: Status Change . Is there an easy way to do this or do...
(Multi-page thread 1 2)
August 9th 16 10:26 AM
by chungcu168 Go to last post
16 4,515
blank if sum is less than 0 by freds
I'm trying to get a blank (or even a 0) if the sum is 0 or less. Here's what I have in the cell SUM(D14-E14) I have answers that go negative but I'm...
6 3,563
Conditional difference between cells by jlclyde
Hello, I have a spreadsheet that I am trying to calculate the hours between two different cells based on the conditions of other cells. For instance Q:Q =...
August 6th 16 05:28 PM
by banhtrungthu58 Go to last post
2 438
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 418
Date sensitive formulas by prattingabout
Hi Is there anyway to stop a formula from updating after a specific date without manually pasting values? Any help would be really great, thank you.
July 31st 16 08:27 PM
by LeHuonngh2 Go to last post
2 577
Edit & paste link help by Martin [_4_]
Hello, I have 16 spredsheets with people like this who are Communicants G . McCormick Mr & Mrs J. John & Grace Address Town Postcode D. McCarley Mr & Mrs...
July 31st 16 04:59 AM
by XLS S Go to last post
1 625
SUMIF alternative by Dave H
I have a spreadsheet that has 13 columns the first column for an identifier then 12 more columns one for each month. I can add a sum column but my data is...
July 31st 16 04:53 AM
by XLS S Go to last post
3 547
Crosshair is missing when I try to click & drag a cell by Maureen
All of the sudden the black crosshair went away in Excel. I still get the white cross, but when I hover in the bottom right corner to click and drag the...
July 30th 16 11:29 AM
by BùiÁnhn1 Go to last post
7 5,759
vlookup last occurrence by Jack Sons
Hi all, I need a vlookup worksheet function (Excel 2K) that works with the last occurrence of the search value in the reference column in stead of the...
3 1,399
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 477
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 20,058
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 540
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 492
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 495
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 621
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 616
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 831
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 655
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,970
Post New Thread

Display Options
Showing threads 141 to 160 of 146459
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:12 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.