Hi all,
I have a cost model for housing which is all set up using dynamic arrays and in a few instances 7-8 cells I had to use LAMBDA functions, for example, SCAN, BYROW, MAP and so on so perform certain calculations. In a final sheet I have a data table that performs the same calculation for...
Can someone please help me?
I'm trying to use SCAN to ascertain the 52-week highs and lows for stock prices.
Like these:
close52-week high?
$ 44.36
$ 44.04FALSE
$ 44.36TRUE...
Can the Excel SCAN function work on a table a calculate a running total for each column individually. I tried the following formula:
=TRANSPOSE(SCAN(0,TRANSPOSE(Table_Array),LAMBDA(a,v,a+v)))
However, I get a running cum by column for the whole table, not for each column individually.
Hi all,
I am trying to figure out how to calculate the Exponential moving average of a stock. The sheet shows the steps involved. I tried using the scan function but I couldn't figure it out. I hope someone smarter than me can help with the formula or point me in the right direction. I know I...
Good Morning
how would I go about reading a text file and scan for values? If found return the header line.
the text file has a header on line line (Test1)
the second line has all the IP values
between each group is a blank line
the text file looks like this? (test.txt)...
Dear Members,
I need assistance in creating a CAGR array from periodic returns vector.
I wish to create a Dynamic Array holding only calculated CAGR (compound annual growth rate) values derived from periodical return on investment vector.
This is easily performed in standard Excel but...
<a href="https://fhexcelphotos.shutterfly.com/pictures/9" target="_blank">https://fhexcelphotos.shutterfly.com/pictures/9
https://fhexcelphotos.shutterfly.com/pictures/10
Hi All,
Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or...
Hi,
I have a cell start from C7 to C10001.
The data here is between PASSED and WRONG.
which i created a simple barcode scanner purpose.
How i can use a VBA code to stop scanning purpose if WRONG item scanned in the cell(C7 to C10001)
Also a popping error message tell that you scan a wrong item...
Hi, If this isn't appropriate, please forgive me and let me know. I have a small business and am looking for a simple solution to taking inventory at the end of my season. I would like to be able to scan barcodes to enter the info. I would also like to be able to scan an item 3 times, for...
I would like to know if this is possible. You can use Excel to scan in a Barcode from various products, it scans into a cell and either you autotab or click to the next cell to get the next barcode. When you sell a product like books you notice that certain data is consistant accross related...
Hi Guys
I have a limited knowledge of excel, but unfortunately I have been volunteered to implement the below:
I want to able to do the following:
1. scan a product in that it registers in excel
2. then scan it into the stock location area
3. then scan the quantities , I presume we have...
Below is a sample of the current code I am using in excel to highlight cells when our products are in a box. The code worked fine until I increased the number of Rows it needed to go through.
I'm not very good with loops so need some help rewriting this as a loop;so it can scan 200 rows x 7...
Hi all, I've searched with little luck, I'm new to excel and can't edit these VBA's by myself enough to solve. :confused:
I want to scan Column A for characters or strings in column B and replace them with Column C, in this case a blank.
May I have a VBA macro to scan list A2:A5000, replacing...
Hello
We have a one field continuous form that we use to scan numbers into. The problem is after each barcode is scanned the user must hit tab , enter or use the mouse to navigate to the next record. Is there a way to have it move automatically ready to receive the next scan with the user...
Hi all,
I bought a bar code scanner (a cheap one for 20 €). I would like to scan the barcode of the receipts and scan only date and total amount in predetermined cells.
My question, is this possible with VBA? …without any extra software or costs.
And if yes, how?
…. Is there...
Hi, I have a spreadsheet with a few hundred items on it and these items are occiasonally getting sent out and then returning to me and I want to to book them in and then out so I know what is happening.
I currently have a tab with all of the items on it and then I have created a new tab for...
I have a spreadsheet that users need to use to scan in bar codes. When they try to scan the bar code the cell populates with #NAME ?
The cell is formatted as General
Any thoughts about what is causing this?
We are considering switching from MS Access to Excel for a simple (??) time logging system
Using our access database, when a worker starts a new part of a job they go to the computer, grab the barcode scanner. They scan their name, the process the are embarking on (e.g Bending, or threading)...
This is my first time posting so not sure if Iam doing this right.
I want ascan out/in system for scanning items out and back in again with a time stamp,below is what I have a the moment
LabelCode Time Out Time In
0615W 05/02/2019 11:00...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.