portion

Hi, I have an excel sheet given below. The pivot table shows the "Amount" portion correctly but in the "Qty" portion, values which are repeated are shown only once. How to show all values in Rows?? Excel 2007 32 bit ABCDEFGHIJ 1Sum of AmountColumn LabelsComm.L / ULQtyRateAmount 2Row...

Hi, I have thousands of strings of text like this one in an excel sheet (Pembina Pipeline Corp. 3.54% 02-03-2025 Callable MTN) and what I would like to do is to build a formula that goes through those strings and remove all text to the right of the year in those strings. All strings have 3...

Good afternoon, I have a range containing a series of values in hh:mm:ss format. If any of these durations exceed 10 minutes (the "10" being contained in a worksheet range ThresholdMinutes), I need to extract the minute section of the string and add it to a string variable MyString - this is...

Hi all, i spent a good portion of the day trying to figure this out without any success. I created a macro that uses a system generated report to sort data and transfer it to a separate sheet. The thing is, the report is generated every day with sheet name as "Ledger Account Detail_20190415_"...

Hello guys- I am trying to add another criteria to the below: =IF(ROWS($A$3:A3)>$A$2,"",INDEX(Data!$A$2:$A$110,SMALL(IF(Data!M$2:M$110=Data!$Q$6,IF(Data!C$2:C$110=Data!$Q$8,ROW(Data!$A$2:$A$110)-ROW(Data!$A$2)+1)),ROWS($A$3:A3)))) Would like to add this portion: IF(Data!M$2:M$110=Data!$Q$11...

Is it possible to use the IF/OR function at the beginning of a COUNTIFS formula in order for the COUNTIF portion of the formula to run once one of two text criteria are met within the cells of a specified column range? If so, how would the IF/OR portion of the formula have to be written prior to...

Hi, I have a 20MB file that has 25+ sheets in it. Is there some way of working out or seeing which sheets use up what portion of the 20MB? Thanks

the following formula is used for extracting the numeric portion of the home address. However, how can I add onto this formula to give me the numeric portion of the p.o. box. The addresses appear on a single column but the formula leaves the po box cells blank because it's not finding a numeric...

Many thanks for taking the time to stop by and look at this. Is there an easier way to do this or can this be fixed? Part of a longer formula is not responding as I expected it to. I suspect it's my expectations that are wrong. In essence, what I need to achieve is to identify a "Zone"...

Hi All, In calling xlDialogPrinterSetup from: Sub PromptPrinter() If Application.Dialogs(xlDialogPrinterSetup).Show = True Then Sheets("Data").PrintOut From:=1, To:=12 End Sub When the PrintOut dialog icon is then presented on the screen, if a user cancels this portion of the sub's...

Hi, I was going to write code that put this formula in Columns D to the last Column. =SUMPRODUCT((Sheet1!$A$3:$A$1000=Sheet2!$A3)+0,(Sheet1!$B$3:$B$1000=Sheet2!A$2)+0,(Sheet1!$C$3:$C$1000)+0) How do I make this portion dynamic? Sheet1!$A$3:$A$1314 Is there code i can use instead of putting...

I've had much help on the Forum with helping a friend with his data. This is now sorted into three columns (B-D) The data consists of: b: combined English/French string c: English portion of the string d: French portion of the string It is basically a dictionary This is currently 6700 rows in...

Hi, I think I am looking at this the wrong way but is there a way for me to use a formula to use this to identify a location? I am using a looking for example and I want my formula to pull the location of the cell for one of the parts of the formula. Ill paste formula below...

I have determined an IRR of a commercial property from its cash flows after a sale in year 10. How do i go about figuring out what portion of my IRR comes from cash flows and what portion comes from the sale of the property?

I have a two part formula that has work wonderfully. I am not updating it to do a bit more work for me. I have reconciled the 1st part and it is functioning as expected. The second part is the issue. I cannot seem to get it to work correctly. The formula before making adjustments is as...

I am trying to find out if there is a way to print just a portion of a protected sheet in Excel professional plus 2010. I went to the page break view and just sized down the blue box but I am wondering if there is any other way to print a portion of a protected sheet without knowing the...

AoA, Basically i converted a list from pdf and now the first name middle name and last name are in different cells but i want to combine in one cell but as a different persons names consist of different Parts some has first middle and last where some have even on five portion plz tell me how to...

In the image the above portion will be the data that is downloaded. I need to find a way to transpose the data (into a new sheet) so that the highlighted portion is what gets displayed. Can anyone point me in the right direction for a tool or formula that might allow me to do this?

Hi, for our current project we are limited to adding information in a single cell... so within the cell is there a way 1) to hyperlink only a portion of the cell. E.g., Please refer to https://www.google.com & only https://www.google.com is hyperlinked, and 2) is there a way to add multiple...

Hi, I am trying to plot a Mandelbrot using "gdi32" library function SetPixel after setting 1DC = GetWindowDC(0) Seems to work initially but the Excel window seems to reset/refresh halfway through the plot and either stops plotting or the completed portion of the plot disappears completely. I...