store

Hello, Please see the table below: <tbody> Store Name Sales 2018 Rank Store Name Sales 2019 Rank Store A 700 1 Store B 400 1 Store B 500 2 Store A 350 2 </tbody> I am looking to do two things: 1. I need to find the difference in sales for...

Hello, I am to create a rank comparison formula. Can somone create a formula that tells me how many ranks a certain store has moved up or moved down? Example: Store has a decreased rank of 2 (from 1 -> 3). See below. <tbody> STORE NAME RANK 2018 STORE NAME RANK 2019 Store A 1 Store D 1...

Hi Guys Hope this is possible. I have a neat little single dice roll set up, but now that is working, I want to "store" the results of each roll in consecutive cells. So, dice roll 1 scores a 5 store in cell G1 dice roll 2 scores a 3 store in cell G2 dice roll 3 scores a 1...

Will Excel keep track of invoices? Example; I generate and invoice and the next day i generate another, will excel store the info and add them up to track income?

all, I need help I have 3 columns of data store id, store name and item no if I create a Pivot by store name and count of item no I get 250 store names and counts this works the problem is I am trying to perform a distinct count of SKUs across 5 stores I can do this in a pivot using...

I need to store the results of my for each If statement in the results worksheet of the active workbook. My loop works but I need to be able to store the results in column a and c from the results worksheet This is the code for the loop For Each cel In Range("A4:A85")...

Hi , I wanna add A with B then store the result in B. thank you

Please see attached doc in the link below. How I return total amount deposit in Deposit Info Tab column C for the right store and date ? http://s000.tinyupload.com/index.php?file_id=92403949706254717342 Thank you!

I have an Excel workbook that has a sheet that has a list of 500 stores numbered Store number 1, store number 7 store number 11, etc.. - these are my test stores. The store number is in column A. I'm calling this sheet "500 Test Stores". The sheet doesn't contain duplicate store numbers, it is...

I have the sample sheet below. I need to count how many y's and n's there are for each ad week per store. I tried a few different countifs with no luck. Any help is appreciated. <colgroup><col width="22" style="width: 17pt; mso-width-source: userset; mso-width-alt: 804;"> <col width="73"...

Hello All! Got a query which I hope someone can help with.. I have a spreadsheet that I need to create for work due to a new process. Essentially what I need help on is a formula which automatically breaks down the allocation (column B) into packs (columns D-M). Below is a shortened version of...

Hi All, This is my first post here and hope will get my answer here. I have a table with 3 columns, store, Weighting and matrix. I need the unique store list from the table but weighting and matrix columns should be added or concatenated before deleting the duplicate rows. Please find the below...

I have a sheet where Multiple cells in row A captures live data using RTD function. I wish to store the same data upto last 10 values in rows B to K For Example If last RTD value in cell A1 is 10 and when A1 auto updates itself to say 11, it should store 10 in B1, and when A1 gets updated to...

Hi Everyone, We are looking for any recommendations on the various online database options(Caspio, ZOHO, etc) to store Excel tables on a daily basis. Thank you!

Have created a few macros, which are currently store in my personal macro workbook. I want to make the macros available for many users in my company, but I keep updating the macros. Can I export the module from my personal macro workbook and store them on our shared drive. What is the best...

This is what my data looks like <tbody> 60633082 60633006 60633084 60633080 60633046 1 9 2 4 1 3 2 0 0 1 2 0 3 2 1 2 0 0 4 0 0 0 1 1 5 2 3 4 0 1 </tbody> This is what I need it to look like: <tbody> 1 60633082 9 2 60633082 0 3 60633082 2 4 60633082 0 5 60633082 2 1...

Hi! Can I store a multiline text which contains formulas and text and use a macro that will activate the A1 cell and then paste the multiline text? Thanks!

So I have a table with multiple columns, each representing a store. The rows are individual products while the value is the discrepancy of stock ie we are missing 5 stock (-5). Now I want some sort of tool that can calculate that if I’m missing 5 in one store, I can move 5 from another branch to...

Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like, <colgroup><col><col></colgroup><tbody> Current Shape Required 000003 3 PAK LAND CHEMIST 000005 5 KHALID MEDICAL STORE 000006 6 CHISHTI MEDICAL STORE 000025...

Hi, I am working with a sales data spreadsheet. The spreadsheet's columns are: A) Store#, B) Description, C) Delivered, D) Scanned, E) Inventory, F) Sell Through, G) Previous Day, and H) Past 3 Days. I have the sales reports spreadsheet set up with auto-filters, so I select the store number...