Thank you in advance for your help!
So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this?
For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...
Trying to add multiple data validations for a cell and having hard time getting conditions to work.
Restrictions are numbers between 0 and 100 or just the text value of x. Any suggestions
would be great!
I have a list of thousands of names that need splitting into columns: prefix, first name, middle name, last name and suffix. The full names are varied and therefore the formulas I have tried thus far do not work on the whole list.
Formulas I have tried thus far:
Hello everyone I would like to thank you all in advance for your kind help, I have a good working knowledge of excel, BUT I am rather new to VBA and I could really use some of your help.
So I was able to create a simple formula that looked at cells Sheet2 A8 and B8 to create a hyperlink in C8...
This should be simple but I am finding it baffling
The formula that works:
I get the result 12. My understanding is that this is the row which the value of B4 on the current sheet is found in column E on the specified...
I'm attempting to copy an Excel cell, and paste it into another program (in this case, Adobe Analytics). However, it's inserting a space after every newline. Ex:
Instead of this
-It does this
(but instead of "-" it just does a space)
When I paste it as text to MS Word, and...
I am creating a Visio diagram from the data in excel with VBA. My data has a column of names and a second column of addresses. I am able to drop the shapes into Visio and specify the shape (circle, square, etc) based on the name. I am able to put the name on the shape text. I need to change the...
For a worksheet I'm making a comment form. What it does is simply add some text to a cell the user selects. What I've been unable to figure out is how I make only the added text in red, while the rest stays the same (black). Right now it add's the text from a Textbox to a cell. It...
I have a table of data with many rows an columns and I'm trying to count the number of records that meet numerous criteria. I've managed to get a lot of it to work but am stuck when it comes to one field that contains one or more partial string elements. My current formula is: -...
Hi there, I am trying to write a formula that is a IF statement with 2 different SUMIF criteria based on the true of false result but the false default is overriding the true.
my formula that I am using but it does not wotk the way I want it too:
Hi, first of all thank you for looking at this post.
I have started a new job and am wanting to improve the speedof the month end process.
I have to download the information from Excel from thenominal ledger to review (approx. 3000 lines) some of the values are the same butare pluses and...
I have equations including text, providing information on source directory & save directors the VBA processes.
In some cells, they evaluate. For example:
In cell B3, ="J:\ACCOUNTS\Credit Cards" & B15 & "" evaluated to J:\ACCOUNTS\Credit Cards\2018\
In cell B4, ="J:\accounts\Xero\Credit...
I'm trying to do multiple text searches in a cell and return text if true. If not true then I want the cell to be blank.
Column A is PaymentNotFound12345 and I want the formula in column B to search for "PaymentNot" and return "PaymentNot". However I need to also search for other...
I cobbled together some code from multiple sources that will process text files.
Since we have multiple files in a folder that need to be read, I built the process to read all of the filenames in a folder into an array (DirectoryListArray()) that I use as a master list of files, then...
I have a range of numbers at A2:A10. Column B shows the progressive sum (e.g. B2=A2, B3=B2+A3, B4=B3+A4 etc). Column C will either be blank or have a certain text "ABC".
I would like the progressive sum result at column D instead of B with some criteria. I need a formula at D2 which I can...
im trying to list/extract all the text from Z16:Z116 when another columns date falls between a start and end date.
Z16:Z116 = text to extract
AV16:AV116 = contains date
A1 = start date
C1 = end date
is this possible?, I've tried Lookup & Index formula I have found on forums without...
I've got a lot of cells with useless text and a combination of text + numbers in it that I need and by now I am out of ideas...
Sometimes it looks like this:
Useless-Text_CD_local random, name (randomname) 2019-10-17T08:20:15 XYZ-COUNTRY-000737
Or like this:
Can someone assist me in writing a formula for counting how many "I" are in a range of cells. For example I have a range of cells B11:AF12 that have different letters in it to identify the kind of Lead Source we receive. "I" represents Internet. I need to find out how many I's are in...
So I am trying to create a formula that compares to different cells to make sure the area assigned is correct. The problem is how the text is written ...
Cell B1 the text reads "Group 55 Region E Area 558"
in Cell B2 the text reads "55E8"
I need a formula that compares B1 to B2 that shows 55E8...