show

  1. D

    Convert ddmmyy to Qtr yy

    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.
  2. D

    Unique list from table in Power query (don't show 'NULL')

    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...
  3. T

    Set cell not showing value

    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
  4. M

    Show partial text + expand it on click

    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.
  5. P

    Show servers with specific software but show all software loaded to those servers

    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...
  6. L

    SUM IF AND subtotal & filter dates

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

    Forms using Data

    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...
  8. B

    Remove red indicators from notes excel 2016

    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...
  9. S

    Display set range of numbers between an upper and lower limit

    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...
  10. R

    Show value as height while referencing weight for calc

    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.
  11. D

    Formula to show whether invoice is paid AND/OR approved

    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...
  12. P

    Dynamic Find and Replace

    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...
  13. O

    Sum / Total Error

    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 &...
  14. O

    INDEX / MIN Issues

    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...
  15. L

    ISBLANK question conditional formatting

    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())...
  16. Welsh Mark3

    Max Value?

    <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.
  17. A

    Expiry Date of Excel

    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.
  18. L

    find date in past based on dates day number the show show cell value in same row

    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...
  19. S

    Counta inside Vlookup

    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...
  20. C

    showing the total number of products not just if they have it

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top