I need a formula for cell D2.
I apologize but not using excel frequently I have lost so much knowledge I had before with an IF/THEN statement.
I'm making a spreadsheet (simple) with B2 being a validation cell with LIST. In the list are the following...
TAGS - Metal Detectable Hardback
Trying to post a question and I have included two tables, but for some reason I get the error message "The number of tags you tried to add exceeded the maximum number of tags by 1"
Is there anything I can do to fix this?
I have a table with a column named "Description" and another column "Tags". I have a named range "tag_data" that lists all the tags I want to search for in the description, and then concatenate the tags into the Tag Column:
I am using a function I named ConcatenateArrary based on a...
I am trying to locate Meta tags from the following URL:
However, what is passed from the result string to HTMLDoc.body.all is only a...
I would like to set up a link from a cell to open an Explorer window and search for tags that match the cell's contents.
An example would be:
1. Click a cell that reads "Golf".
2. An Explorer window opens and automatically searches for any files tagged with the word "Golf".
I already have a...
Good Afternoon Excel Gurus,
Need help from the gurus with a quick formula to achieve the following result. I have a lot of sheets to fix and all sheets have 1000's of rows.
Column A has tags starting with numbers and some starting with characters. I am trying to write a formula that can...
Please help me to make a program using excel which I can use in my current work. As you can see I have a series of inputs from column A to column F. What I want to happen is when I input a tag or series of tags on column H starting at H3, it will scan all tags at column C and all similar tags...
I can successfully parse the CA Agile Rally API to return information into a worksheet, but the information returned in the description field is full of HTML tags. Is there any way to pull or publish the data in that field without the HTML tags?
This post is regarding the addition of tags to spreadsheets on Macs vs Windows, Excel 2016.
For my Excel Spreadsheet class, one of our directions after every assignment is to add some words in the 'tags' section based on the assignment. When I create a spreadsheet on my desktop, which has...
Frank here. Can anyone help me work out how to: A1 to A60 are numeric. I want Column 'B' to make a progressive descending total of Column 'A' figures. New at this so yes help would be great, Thanks, F PS: What does it mean when it says here something about 'Tags"?
don't know what the poster has done here:
but it looks as though the whole page is inside a set of code tags (or two)
My response is 'trapped' in there too.
It's a pain to scroll through the...
Using VBA I'm able to create and save an excel file to SharePoint and set relevant tags using the .ContentTypeProperties() value. In order to publish the spreadsheet I want to create a PDF version in the same location, but seem to be unable to do so because the 'tags' aren't set...
I have a need to convert Allen Bradley RSLogix tags from one format to another. I can save the tags into a .csv and open in Excel. I would like to write a macro to convert them into another format. Here's an example:
Old format: New Format:
I have a file that creates barcodes in a specific format. The trouble is, you can only make 24 at a time before you have to print them. I'd like to have a way that you can crate as many as needed and, as the sheet fills up, another sheet gets created and so on...
You scan on 'Scan Sheet'
Because of the CODE and HTML tags used for posting codes in the forum, the VBA code i have posted in the link below is not the same as i have posted.
I tried to turn OFF and ON the tags but...
Hi Everyone. i am trying to scrape li tags that shares the same class name
the HTML cods looks like this:
<ul class="top-section-list" data-selenium="highlightList">
<li class="top-section-list-item">sample text# 1</li>
I have a custom ribbon with controls that I have tags associated to. I can change visibility of groups and controls by changing the tag property:
I was wondering if there is a possibility of making the same by not changing the tag property, but directly...
I need an Excel macro that finds words or phrases in uppercase, then surrounds them with the html tags for bold. The uppercase words can have as few as 2 letters like "NO", and there can be more than 1 word in uppercase, in which case I want the tags to surround all uppercase words that...
I use code tags to post code in threads aka
Usually, I write the code in the VBE to test, then copy and paste to the thread inside the code tags.
Unfortunately, it seems to add extra "lines" in between the code, usually after Sub, which means I then edit...