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
Page break preview has thrown a wobbly by Martin [_4_]
Helo, Page break preview will not let me adjust the margins properly Each tile I drag the margins to where I want It ends up with what looks like a page for...
December 17th 15 05:38 PM
by Martin [_4_] Go to last post
0 650
Convert visa pdf statements to three columns in excel? by imogen b
hi, I would like to download data from a pdf visa statement into an excel spreadsheet. (My visa company will only download three months of statements into...
December 16th 15 09:13 PM
by Claus Busch Go to last post
2 683
Help Required - 11th Dec 2015 by Akash Maheshwari
Hi Team, I have two Columns. Column A is for Email ID & Column B is Mobile No. What I want is if I try to enter any duplicate email id in Column A then...
December 10th 15 09:17 PM
by Claus Busch Go to last post
3 713
Help Required 9th Dec 2015 by Akash Maheshwari
Hi Team, Greetings!! Require a solution. I have used a Rank Formlua which displays 1-8 Ranks. if 1 is displayed it should reflect 1st in the cell if 2 is...
December 9th 15 07:36 PM
by Akash Maheshwari Go to last post
2 706
Signature software by [email protected]
Hi has anyone any experience with using signature software to obtain a signature within Excel? The idea is to ask someone to sign in a spreadsheet on the...
0 569
Cut, Copy, Paste, PasteSpecial grayed out. by news.microsoft.com[_6_]
Puzzling problem: In Excel both under "Edit" and in the shortcut menu "Cut", "Copy", "Paste" and "PasteSpecial" are grayed out. Just started today.Files are...
8 3,837
1 Attachment(s) Drag down a formula which uses multiple columns? by RegisteredBanterMerchant
Hi, Banters the name, Excel is the game. got a another problem Boy$. I'm working out an average of a Column B. To do this I need to work out each row...
December 4th 15 10:52 AM
by RegisteredBanterMerchant Go to last post
0 553
Look up formula? by [email protected]
Hi, I have a row of numbers (C2 - N2) that are assigned to names in row C4 to N4. I need to right a formula that will rank these 12 names by the highest...
2 645
Insert Rows Below by ExcelUser73
Hello, I'm trying to insert rows below a row. I first run a filter so that some rows are showing then I want to insert new rows after each row that is...
9 1,831
Guidance Required #01 by Akash Maheshwari
Hi Team, Require a formula for the following situation: CELL A1 contains a Time CELL B1 contains a Writeup as Morning Report / Afternoon Report / Evening...
November 30th 15 12:19 PM
by Mandeep Baluja Go to last post
6 687
Values from a weighted average by JK123
Hi all, I am new to the forum so hopefully this is posted in the correct place. I am trying to three derive values from a weighted average that I know. The...
November 30th 15 01:11 AM
by zvkmpw Go to last post
1 590
Expand/Collapse Grouped Data in Protected Worksheet by Robert Slattery
I've created a worksheet that will be distributed to 300+ users in an investment group. It contains formulas and computations in cells that could easily be...
November 24th 15 06:08 PM
by GS[_6_] Go to last post
8 4,874
Convert seconds to hh:mm:ss? by Terry Pinnell[_4_]
Is it possible with a single formula to convert a number of seconds sssss to the text hh:mm:ss please? For example, 6185 would become 01:43:05. -- Terry,...
November 23rd 15 03:17 PM
by Frozen Go to last post
5 641
Need Help with ROUNDUP by [email protected]
I need to combine a formula and ROUNDUP to arrive at the next whole number value of a formula and do not want to burn a cell calculating the value of the...
November 22nd 15 06:19 AM
by pedro Go to last post
5 686
Formula in Col B to detect if an entry in a list in Col A is uniqueor not by [email protected]
I have a two column spreadsheet. It has thousands of rows. Col A contains a text entry in each row from row 2 onwards (row 1 being the header). I want Col B...
2 498
Export a text file from each row of a spreadsheet by Greshter
Hi, I'm sure this has been done before and is in other threads but I thought I'd ask. I have a series of rows that I need to export as individual text files...
November 16th 15 07:21 PM
by GS[_6_] Go to last post
2 475
Dynamic Hyperlinks by [email protected]
I have a workbook with 40 some sheets. 1 is a summary sheet and the others are the detail. Some detail sheets have more than one piece of information. Each...
November 14th 15 07:19 PM
by Claus Busch Go to last post
3 548
Office 365 Home Premium Excel vba options greyed out on developer tab by michaelberrier
I use Excel as part of Office 365 Home Premium, and recently I had a workbook I've been using for a while with macros open with the message "We found a problem...
November 14th 15 04:20 PM
by michaelberrier Go to last post
0 450
How do I suppress a zero value or #VALUE! for a Pivot calculated i by DJL
I have entered the following formula within a new calculated item to calculate the variance between actual and budget values with the view to making zero...
(Multi-page thread 1 2)
10 929
Vlookup is giving #N/A by [email protected]
I have this formula in a spreadsheet and it's bring back the correct items needed. However, if there is nothing to bring back, I'm getting #N/A. I need it to...
November 10th 15 05:20 PM
by Claus Busch Go to last post
1 384
Post New Thread


Display Options
Showing threads 201 to 220 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 09:17 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.