appeared

I need to count how many times an item went from a certain source, and afterwards from which source it went the most. Say... <tbody> Source Item Wallmart Apple Wallmart Apple Newegg Apple Target Apple Wallmart Apple Target Apple Wallmart Apple </tbody> How do I, on a new...

Hi everyone, I would like to find a formula that will calculate how may cells back when a digit appeared. For example, A1 = 2 B1 = 2 C1 = 2 2-2-2 9-7-0 8-1-3 1-4-3 7-3-5 9-2-9 6-6-8 2-0-7 1-4-8 7-7-2 Step1: Count how many cells back until the 1st digit 2. In this example the 1st 2 is 5...

Hello, I hope you can help me with an issue two colleagues of mine have experienced: they opened a xls file and a 50,000 amount appeared as 50 for both of them. Even when clicking on the cell, the amount was shown as 50 in the bar on the top. The amount appeared correctly for me, so I guess...

Hi everyone, Need help with creating a formula: Digits = 0 through 9 Cells P4 through R4 are the most recent digits Position 1, Position 2, Position 3 Trying to calculate how many rows back when all 3 digits 9, 5, 4 appeared. So using the example below. The 5 & 9 (from cell range P4 through...

Hello everyone, I wanted to ask if a formula or vba code could calculate the following: 1>I have a random set of digits 0 through 9 in cell range F3:F23. The digits in the cell range are in the order/sequence. So cell F3 is 1st, F4 = 2nd, etc. F3 = 2 F4 = 5 F5 = 0 F6 = 5 F7 = 0 F8...

Hi everyone, I'm currently transitioning to PowerBi and is in a bit of mess with converting excel formulas to DAX. I am tryin to get the number times the store_number has appeared each day the get the average number of times it appeared for the month or week. thank you in advance as this site...

I have data that shows me Product ID, Date appeared on report and quantity of product. I want to understand that if the product appeared on the report for X days (excluding weekends) then there was a break in the date trend (ie a weeks gap), then appeared again, how I can count the amount of...

I view 1000's of numbers each day on 3 monitors each of which is a custom database tied into a custom database. The key field for each is a product # like '12094'. It would save so much time daily if I entered '12094' in one cell of the 1st instance of the database and it appeared in the other...

Hi guys, I'm currently looking for a formula that will allow me to count the last 'X' number of instances a value appears in 2 rows and then find the corresponding value in another row. It's best to show this with an example: For this image I need a formula which will count the first 4...

Hello, I have done a userform to count some items that I have in stock. I would like to have a userform that could count each item and that numberwould appear on the the textbox. The other values that appeared in the image, total items, percentage vs target,etc would also appear on the frame. Is...

How do i rid this setting in Excel options (formula). Seemed sometimes this box was untick by itself. And cause error of "these are one or more circular references.." appeared when opening my workbook. Is this anyway to fix this by VBA or any method. I don't need to adjust the tick box every...

Dear Sir, Greetings!! Into excel file, in the Edit Links box, reference file is appeared. But while searching the same reference file across the sheets nothing is appeared I have also tried .xl into Find and replace box but the same result Though other links are shown but not the link I am...

I have following formula in Cell B11. =IF((COUNTA(A2:A10)-COUNTIF(A2:A10,A2))=6,"Y","") It checks if the value of A2 cell appeared 3 times in a last nine rows and show Y or else remain blank. I want to check values of all 9 cells from A2:A10 and display VALUE in B11 only if following...