show

Afternoon Ppl, need some help here, how do i convert eg 25122019 (ddmmyyyy) or 251219 (ddmmyy) to show its Qtr4 19 ? Any solution to this ? Much thanks.

https://1drv.ms/x/s!AvjBsEPEq12ngSTtNlKRTZmnoBHr?e=k1ek3y I have created a Custom Column using List.Distinct on the Payment Date column. If I expand these values, the NULL values will also appear. How do I make it such that it only shows the dates when I expand the values in Power Query? That...

I want to show c.Value in the set Range elrepcol. elrepcol remains blank. How to show c.Value in the cell? For Each c In ActiveSheet.Range(("D131"), _ Range("D131").Offset(, 40).End(xlToLeft)) _ .Cells Set elrepcol = Range("AK1").End(xlToLeft).Offset(, 1) elrepcol = c.Value

Hi, I have like 3-4 paragraphs of text in each cell, I would like to display only the first line (keep 12.75 row height) and if i click on the cell, to expand to show the full text. Like a "read more" on the cell itself Thank you very much.

I have a workbook with only two columns. Column A contains the server name. Column B contains the software names. There are up to 100 software names associated with each server. I need to see all the software on the servers that have software X loaded. If I filter column B for X all the...

Hello i have list of fruits salles i want when i filter by date it show the total of each fruits salles

All - I currently have a drop of data with 3000 rows and 26 columns of data that I need I need to filter based off a certain city within the data Would like to create a summary form with the cities and when I click on the certain city it would then show me all the info for the pertain rows and...

Hi! I have a sheet with a lot of comments which show additional information. With al the red right top corner triangles for every comments it gets very messy. Is there a way to not show these indicators? I found the 'no comments and indicators' function in Excel but this automatically removes...

I've got a sheet that works out the lower and upper limits of parts based on certain criteria, I want to display the parts available between and including these numbers. The 13 available numbers are based on the strength of the part, so 35, 40, 63, 65, 80, 85, 100, 105 etc. If the cells show 63...

I have two columns one with heights (i.e. 6'6", 6'7" etc) and one with weights say column I and J. In another cell C2 I would like to be able to enter a height, while still displaying height, yet for a calculation use the corresponding weight.

Book1ABC1InvoiceApprovedPayment Date2150001/01/193150001/01/19415162501725018292103113121314InvoiceStatus151Paid162Approved173Not ApprovedSheet3 Hello guys, I have a sheet with invoice information which can be categorized as either: - Approved = there is a value in Column B but not in Column C...

This is my first post, so apologies if I miss anything out! I have a selection of data in a Worksheet and I am currently using a find and replace array to correct some data before it get put into a Pivot Table. The problem I am stumped with is that the source cell (Column D) can contain a...

Hi, any help appreciated! I have a spreadsheet and in column FO (highlighted yellow) I want to show the total of columns FN, FQ & HE. I have attempted this, but it only seems to work for some rows, I get errors in the others. All I want is for the column to total those other three (FN, FQ &...

Hi. Please see ‘Example’ file via the link, below. https://1drv.ms/x/s!AtIvkRgReIvwgRcNSvXr5zlzQZXA My problem relates to columns BF and BG in certain cases. In cases where the finishing position is the same in column BB and BE (sub-event #1 and sub-event #2: green highlighted area), I...

Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format? I must be close but am just missing something. I've tried searching with no luck. ISBLANK(D3,"")=IF(D3<TODAY())...

<tbody> Month Value Desired Result 1 10 20 1 20 20 2 20 50 2 50 50 3 150 150 3 5 150 </tbody> I am treying to write a formula that finds the maximum value in a given mnmth. The table attempts to show what i am trying to do, the desired result is the value i am trying to produce.

Dear Expert i have some files for which i want excel stop working after specific date excel cannot open after 31-Aug-2019 and show msg "Contact administrator" please send me macro codes for this.

Results to show in columns F,G and H. Please if possible don't use VB scripts I would like excel to look at the days number in column A (7/6/2018 = 6), then go back that many days (including the day). For example: In Column A, If today is the 6th, then go back 6th,5th,4th,3rd,2nd, to the 1st...

I am trying to remember how to do something i had done before. Two separate tabs, lets call them A and B. On Tab A is my summary of everything happening on Tab B. Tab B has columns made up of dates and amounts What I am trying to do is have a certain cell on Tab A that does not move show the...

HI All I regret that In my job I don’t get to do as much work with reports as I would like as I just keep forgetting some of the basic stuff never mind the more complex formula’s and strategies. I have a sheet called raw data that shows the company name and products that our customers have...