suppose

currently i i want to look up a unique security ID to another tab and return the inventories its in. the problem with obviously vlookup is that it would only return the first inventor result found.....what would be a way to return all the inventories the security ID is in? i suppose this can't...

Hi I typed =now() and I got 4/25/19 8:31, then I changed cell format to general and I got 43580.3552 My question, how can I get 4/25/19 8:31 back (day and time) from that number 43580.3552 ? (suppose undo is not working)

Hello fellows. I have a doubt on Excel calculation. If I change the A1 value the B1 should automatically change to 1 the same if suppose I change B1 value the A1 should change to 1 Kind Regards

Hi Guys I am trying to fix a formula that i have no idea what it is doing. the formula is IF(DATEVALUE(F1)-TRIM(D2)>=0,J11040,IF(DATEVALUE(F1)-TRIM(C2)>0,DATEDIF(C2,F1+30,"m")*E2,0)) below is the data <tbody> A B C D E F 1 total month number start end per month 30/04/2016 2 54.95 1...

In sheet 1, column A - I have a column listed with some name, suppose Bill Jordan James In sheet 2, column A - I have all the names of sheet 1 column A multiple times. In sheet 2 column B - there are two results "yes" and "No" for each names. Suppose, Bill ------------------yes Jordan...

Hello I need to 'de-code' someone else's left over codes..and have come across this line Range(Range("Outcome"), Range("Outcome").Offset(UBound(meanoutput, 1), UBound(meanoutput, 2))) = meanoutput I suppose that I will need to replace "Outcome" with something else, but first I will need to...

Hello, Got an Excel problem I'm struggling to solve. I need to be able to count the number of Numbers in a cell. So if a cell contained the text 23,24,25 The output would be 3 Is there a way to do this? I suppose the easiest way would be to count the commas? but.. there may be entires with a...

Hello everybody. I have to determine a range in the following situation: Dim lr As Long, lc As Long Dim rng As Range lr = sheet.Cells(Rows.Count, 1).End(xlUp).Row lc = sheet.Cells(i, 1).End(xlToRight).Column If lc >= 16 Then lc = 15 set rng = ????? For example: -...

Hi all I have a file with 22.000 lines. They contain our stock codes plus their suppliers (plus some more information but not relevant for this thread). I want to create a separate excel file (or CSV, whatever I can get) for each supplier as there are over 300 suppliers. I suppose someone...

For Excel 2007 - I've got a worksheet with over a thousand filled cells with time 1:30 PM style (this might not matter I suppose?). It has a "start-time" of sorts of 6:00 PM and advances a minute at a time thereafter. A check-cell, that I manually adjust, applies conditional formatting to the...