output

Should be an easy solution but i can't seem to figure it out. Let's say you're looking for a specific word in a data set using the find and replace function and hit 'find all' - it displays all the results for the word you find. All i want to do is copy the 'Cell' reference output and paste...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> The code below generate any combinations I use for example Const v& = 4 to 14 where Array is ("1", "X", "2") (3^4=81, and 3^14=4.782.969) so in the given example 3^4= 81 combinations are generated in the column A and column C & D there is a...

It would be incredibly helpful if someone could help me solve this problem. I have a list of alternate spellings of words (Column B), coupled with a unique number (Column A) Essentially I need a list of all the alternate spellings. There are two rules / means or () means optional sounds...

Hi guys, I am making a macro in excel for a weekly data output from an excel file. i already have two filters included, but the third one i would like to make is a little more tricky. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

I often have several workbooks open. When I run one of my macros, I output to the Statusbar using Application.StatusBar but that output to the statusbar in all of my workbooks. Is there a way to specif which statusbar you want to output to?

Based on the data and output at https://ibb.co/qNmx8Lz What is the error that caused error at 3rd column of the output ? Below is the code that I have been using Sub MissingHobbies() Dim c As Integer, h As Integer, ans As Integer ans = 9 For c = 2 To 11 ' candidates For h = 3 To 6 '...

How would I go about calculating the unique values in Column A based on the criteria that Column B is not blank (any text at all)? In other words, in this example, the formula should output 2. <tbody> Column A Column B 1 No 2 Yes 2 3 </tbody> Any help would be appreciated. Thank...

I am trying to write a formula for the below conditions B1 value varies based on that I need to get output in C1 using below condition If B1>70 C1 should be 40 If B1>0 & <70 C1 should be 20 If B1<0 C1 should be 0 If B1=Exempted C1 should be Null If B1=Not Reached C1 should be Null

Hello. I'd like to count a range of cells that contain any text using the formula: =COUNTIF(H11:H64, "*") Problem is that it’s counting all of my cells since they each contain an IF statement. How do I exclude cells that contain an IF statement that output blank? For example, here’s what one...

Helo everyone, I am using this code to unzip files: Sub Unzip_Files() ' Author: Dreams24 ' Written for VBA Tricks and tips blog ' https://www.vbatricksntips.com 'Declare Variable Dim oApp As Object Dim Fname As Variant Dim Output_Folder As Variant Dim strDate As String Dim...

Hi Is there a way of getting certain pages urls from a website using vba. My following code gets all the urls from a web site page. I enter the domain in L1 and whatever that domain is, it will go to that page and extract all urls. The problem is 1) It only extracts from that page 2) Not...

This will be very easy for, probably, most of you. So I apologize in advance. My spreadsheet has a dozen or so columns, and can have several thousand lines. I am interested in only one of the data columns. From that column, I want to have my output show me a list of the unique values, and...

Hello, I need to calculate time based on a measured output in a table. Basically I'm try to generate a standard amount of time per output. The rules are: 0 to 1 is 20 minutes flat (even if 0.1 is delivered or 0.9 it's still 20 minutes) and every unit after that is 10 minutes per unit (if 2.3...

Hi guys, I am looking for a query that allows me to count how many events occurred between each "x" event. The desired output is illustrated in the picture hereby attached. For instance, the second event is "x" and I would like to have as output 2. In the case of the third one is still "x", but...

I have an Excel file having a Table (data) and a powerquery that result in another table called Output. This file has been uploaded to Onedrive Business. I need to refresh this output table/powerquery ... what is the tools or way I can use to refresh it ? Thanks

Hi, Working on a project to aggregate monthly reporting revenues for a company using Excel. Outline: User inputs data and revenue for 1 team (4 additional teams need to be able to do this) An aggregate output needs to show all user inputs across all teams Before month-end, user can...

Hello and thank you in advance for helping if you can, I have an expression for building a calculated column in an Access query that has worked fine in the past, but I am trying to do it know, and because there is a query linked to this query with the same field, it is giving me "The specified...

Hello Gurus, Need your help with the following: Table 1: Has the following values <tbody> Date Employee Value Numbering 2019-05-15 12345 10 Fill this row 2019-01-04 11111 1 Fill this row </tbody> Table 2: has the following values with a start date and end date as a range and...

Hello - Here's 1 for everyone . . . I have a sheet with item numbers and their associated barcodes. If I do a simple 'Ctrl-F', I can find the correct one but using the scanner to try to scan the correct barcode from a laptop screen full of barcodes is proving difficult. So here's what I'm...

With Webservice I get from Google maps XML response and can calculate car travel time between 2 locations Using this formula to get travel time =FILTERXML(C14;"//duration[1]/text") The output is formatted like xx hour(s) xx mins I would like the format of the travel time converted in [h]:mm format