article

is there a function that I can insert that will count the # of rows containing data, counting downward until finding a blank row? im using a vba script that builds the data and I i could insert somekind of function if there is one (perhaps?) the data looks like this...

Dear mrExcellers, In my company we work with a product database with calculations in it, every product offcourse has an unique article number. In the shared server we have a folder with pictures of every product with the article number as the title. We want to add the pictures automatically to...

Dear Friend ! I have a char and i want to find barcode of each Article, As you can see in my exel table , many article have same article number , name , and Unit but they have many different barcode number because their unit is not same . The problem is when i use vlookup or Index & match...

Hi I am reading a article about when I should user ( ) and when not. I wrote a code below but not sure why Y =1 Sub myfoo() Dim x As Integer Dim y As Integer x = InputBox("enter number") y = MsgBox(2 * x) MsgBox y End Sub Also, do you know where I can read about this...

Hello, I have cell E2 that contains a Data Validation group: "online", "article", "journal", "proceedings" and "magazine". I am populating cell K2 with a formula that is based on E2's entry. If I select an option for example "article", cell K2 will pick cell P2. Here is the logic that I used...

Hi, I have two sheets. One is for planning and second for reporting. Sheet one is article check calendar showing which article to check on which date. For example articles are A to Z and dates are 01-02-2019 to 26.02.2019. Tables format as A1 is header "Article" and B1 to AA1 are dates header...

Hi, Column A: article numbers + products name, for instance "77 Fishing Rod" Column B: sales per product Function 1: If text strings in column A contain 77, 88 or 99. Then sum the sales for those article numbers/products only. Function 2: Sum all sales for products that do not have article...

Hello- I'm a freelance writer working on an article about using macros and other tools to automate tasks in Excel. If anyone would like to be interviewed on this topic, please let me know by replying to this message. The interview would need to be completed by 12/13 The article will be...

In one of the articles, it refers to this link: http://www.mrexcel.com/forum/1960139-post5.html The link is no longer valid. Does the article still exist? How to find it?

Hello All, Need to find the repeated date range in the columns if equal to article numbers. <colgroup><col><col span="3"></colgroup><tbody> Article No. Start Date End Date Result 1 10/12/2018 11/12/2018 Repeated 2 10/20/2018 11/18/2018 Unique 3 10/18/2018 11/19/2018 Unique 4...

I have a sheet (made by some SQL/VBA/Excel expert long time ago). In this sheet I can enter a production run number ("Productieorder / PO") and it will show me all necessary components with current stock, clearance status, total needed stock etc. pulled form an insanely large database. I would...

I have a spreadsheet with authors of articles in one column. Many of the authors have several entries, and there are 100 rows total. For example [ Author t, Author u, Author v] [ Author x, Author Y, Author z] [ Author A, Author b, author x] I have to find out how many times the authors are...

Hello I have this situation. see foto https://ibb.co/gOs76y I have created a userform which contains a ListBox with 4 article and a Comand Button ("Add Selected Article"). ListBox contains 2 columns (Code and Name) I want to add in active cell (C4 in this case) the code of selected article...

Hi, I am looking for a solution for the following. In the column on the left I have different article numbers, each article number has one or more (up to 20) Sales Orders attached to it. For each article number, I would like to see the sum of all Sales Orders attached to that specific article...

Hi guys. I have a table with hundreds of thousands of article numbers connected to customer numbers. All our article numbers comes in different sizes, but many customers have some sizes registered, but are missing some. I have 2 tables: 1. With all the article numbers with the customer...

Hi all, I am looking to find a way to return the latest entry based on 2 cells meeting the criteria C3 is the job number and I3 is the article number on a sheet called "Details" we have the job number listed in column E and the article number in column F The date would be in D if that helps...

Hi All, I have to perform a task af mainting a list of articles and som data releated to it. what i need is an output that looks like this <tbody> Article number article text avg. factor 1st occ 2nd occ 3th occ 4th occ 5th occ 6th 7th 8th 9th 10th </tbody> I have...

Hi guys, Made an account here because i have been trying to figuring this out for hours now to no prevail. Maybe you guys can find a solution. I have a table with several thousand article numbers, and i want to create a new table where all the sizes for the same article number are gathered up...

Article: http://i-programmer.info/news/202-number-crunching/11390-python-for-excel-scripting-under-consideration.html Thoughts? Feelings?

Hi I am trying to follow the instructions on how to combine 2 charts in excel (please see the link below). I am using excel 2010. Can I do what the author did in that article using excel 2010. Thanks a lot. https://www.guru99.com/creating-advanced-charts-in-excel.html