funcation

5/1/24, months of hand aren't even, 8.9, 4.6, 4.8. I can load 2 containers of widgets, with a max qty of units of 9,600,000. I need my months of inventory to be equal in 6/1/24. What formula do I use based on monthly avg, to fill the containers, yet not exceed 9,600,000 so that in 6/1, months is...

Hello, is there a shorter way to do such repetitive calculations? ı havent office 365. https://dosya.co/z4bwpgzkzv2d/xy.xlsx.html

Is there a way in excel to have a select range of columns in a row following a reference cell? Situation: I have a set range that is part of a data pull and populates information off a reference ID# that I pull in from a data set. The downside is that I have some manual cells that I use for...

I am making peer evalution group and rator should be selected randomly among same department collegues. I have a table of records (named "Table1") and I want VBA to randomly return 5 individual number (each number should be on the different cell and table header is called "rator1~rator5") from...

Sometimes when I want to find a name in a list using Find and Replace option, but I make a mistake when typing the name, the result won't come up. So is there a way in Excel that suggests recommendations just the way the search engine works? For example: the correct name in Excel is: michael...

I'm a seller on Amazon. I get a list of top selling products weekly (webpage link). I want to get brand name of that product from amazon. Currently I Have to Do it Manually For Each and Every Product. Screenshot is attachment for reference purpose. Sample Link : Ikea Adde Chair White...

Team, the code and formulas i have typed into a few of my cells trying to figure this out has turned into a monster i have lost control of. Details are below. This spreadsheet is used to summarize overtime for everyone on a shift for a single day. Column F gets numbers manually entered. Column...

Hello, I want to give ROW number in particular cell in multiple worksheet, Can anyone help me with it? :confused:

I have a time value in a cell A1, say 40.56 second. I know I can get the second of 40 by writing x=Second(cells(1,1)). I would like to know how can I get the 0.56? It seems that it doens't have a funcation Millisecond. Thanks.