starts

Hi, i'm trying to get an an amount allocated across a few lots based on its rank. I managed to do this with the formula below (table starts at A1). For apples =MIN(C2,$B$10-SUMIF($E$2:$E$4,"<"&E2,$D$2:$D$4)) For bananas =MIN(C5,$B$11-SUMIF($E$5:$E$7,"<"&E5,$D$5:$D$7)) Now instead of writing...

Hello, I have been looking through different posts but I am still not able to find quite the solution. Basically my problem is that I need to obtain the week number of the year and the number of day of the week from a column that I have with dates in the following format: 1/29/2018 7:08:17 AM...

Hello guys, In I column some of the cells starts with "." It might be start with two to six dots also i.e ".." to "......". After that word will start. Now i want to count number of dots before the word starts and add the count with value 1 the result should be reflect in corresponding cell in...

Hi, I would like to auto-run a macro when Excel is opened and cell C4 contains the word "pallet". I have tried to put this macro in the PERSONAL.XLSB directory and then in "This workbook", however the Macro starts before the spreadsheet is opened.. I did this with a Private Sub Workbook_Open()...

Hello, I'm trying to create a worksheet_change macro in where if there is an "x" in column k cells n:ae in that row would lock. All the data is currently in a table so I don't want to have to put in a valued range ie: k1:k9 but the table starts at row 9 and then changes per worksheet but the...

I have column A, where row 1 starts with 1 and each subsequent row adds 1. For example: Column A 1 2 3 4 5 ... 100 In column B, row 1 starts with 3. Row 100 ends with 1. I need a formula that will fill in column B with the appropriate value. Here's how it should look: ColumnA ColumnB 0 3.00...

Hi, Is it possible to set a range from the last row of data to the first row of data found in Columns AA, My data is varied and the row can change where my data starts from. There are no headers and there may be empty/blank cells above the first cell with data in.

=SUMIFS(Data!$D$2:$D$3924,Data!$A$2:$A$3924,B$2,Data!$B$2:$B$3924,$A3) i have my criterias, now on the column F of Data sheet. i want to exclude if any value of these three value 115 and 145 and XXII and in column G i want to include only if the cell starts with 6 or 5 or 7 thanks.

If my data looks like what I have below, I would like for excel to be able to identify that the second row starts with "F5102" then cut and paste that data to the end of the row above it that starts with "F5101". Then do that for everything that starts with "F51##" until it finds an "F5101"...

Hello Buddies, I have come up some typical problem of preparing the planning/procurement sheet. My procurement planning is based on seasonal medicinal herbs, when was preparing the sheet, I have stuck with from next coverage month to till next season starts, what is the gap in terms of...

Column A contains dates. Column B should show the corresponding weeknumbers of the date mentioned in column A. I currently use: =WEEKNUMBER option. Unfortunately it should the weeknumbers, but the weeknumbers in excel by default starts at Sunday. How can I change this to Monday? Please advise.

Hello I need to generate a list (A1:A23) of working days (excluding weekdays) for the current month. I am currently using =WORKDAY(startdate,1,) with the startdate reference is in F1, but in that situation the A1 starts with the second working day. example: if I put 1 November 2017, Wednesday...

Hello, I am trying to figure out how to write a conditional formatting formula, but can't seem to get it right. I am trying to apply CF if the cell to the right starts with "aa" Any help would be greatly appreciated

hello, how can i get the first 3 digits out of strings in cases the string starts with zero/s? in cases the string starts with zero/s, the function LEFT, ignores the zero/s... thanks

Why does this work: If Sheet1.Cells(1,1).Value Like "a*" Then MsgBox "Starts with a" but this fails? Select Case Sheet1.Cells(1,1).Value Case Like "a*" Msgbox "Starts with a" Case Else Msgbox "Doesn't" End Select EDIT SORTED: Select Case...

=IF(ISNUMBER(--LEFT(H11,"79")),"CORP-ADMIN",IF(ISNUMBER(--LEFT(H11,"10")),"CORP-ADMIN",IF(ISNUMBER(--LEFT(H11,"15")),"MA-RCC"))) The above Formula is returning "CORP-ADMIN" even if the cell value starts with "15". What's going on?

hi there, i would really appreciate some VBA help. i need to divde column "T" values (End(xlUp) by "8", i need the result in column "Y" . my data starts in row 2. Column T data is hours worked. Regards, Odd

=SUMMER.HVIS.SETT(Transer!$G:$G;Transer!$A:$A;$A$4;Transer!$D:$D;formel!$B4;Transer!$M:$M;"224*") In the last criteria im trying to only count where numbers starts with 224, why doesnt it work? It reply 0.

Hi All, having issues in getting a macro to work the way I want it to. my spread sheet has columns A-CO being used and rows 1-199. Row 1 is the column headings. I have a macro that sorts column K alphabetically whoever in doing so it has reversed it so instead of starting at "A****" in...

Hello Guys, I have already searched the entire forum but I can't find similar problem, please help. This string is exported from lotus notes, 122,0,PDDM,"","55BZOR | FDHJ PIP-OBTE-17532, PIP-OBTE-17540_PIPING ISOMETRIC DRAWINGS","","07/31/2017 10:39 AM",96K,5,0 I want to extract the text...