included

Hello, currently I'm working on a tool which will include some macros. I got several sheets with information about articles in columns A-D. All rows should be checked whether this combination of cells Ax-Dx is already included in range xy in sheet "result" or not. If not, the row should be...

Hi, i have values column I and im wanting to set print area until row value is 0. So everything in column I is included in print area except rows where a 0 is found thanks for any help

Hello All, I know I've seen this formula somewhere, when doing a countif on numeric characters, do you need to have the "" included for the search?

Hi again, my last post asked about putting the delta symbol in a validated cell from a list, which also included the letter Y. That is working great thanks to the help i got. The new issue is that I have a cell with a formula referring to the results of the choice in that validated cell. The...

Hi everyone I need to setup a table of content in the following format: 1. Introduction >>(Indent)1.1 Implementation >>1.2 Policy >>1.3 Test >>>>1.3.1 Testing1 >>>>1.3.2 Testing 2 So there are 3 levels of number format. However it is not included in the default format...

I have a column with: 239_ 240__ 250 _B227 Some times a space is included before the number sometimes a space or 2 spaces included after the number. Can I develop a macro which run though my selected cells and remove all spaces and only leave the Number and Letter.

Hi Guys, I've spent a couple of hours trying to solve my issue with Pivottables and formulas, but am now thinking VBA may be better included. I've got a large dataset, and the columns that included that I care about are: -The date -The user number -The test result (Pass,Fail,Blank) I want to...

Hello All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am trying to get a True/False returned in a formula when I reference a date.<o:p></o:p> <o:p></o:p> For example, when a date is on a predefined list/range (and/or) a Saturday or a...