shows

Hi Everybody, I know this is one is probably an easy one for you all. I have a long error report I need help with. Attached is a sample of the spreadsheet. Column J shows where the error is located on the spreadsheet. Is there a way to highlight the row where the error shows up? For instance...

I have this problem here: I have a list of 300 users of a site. Each user has one department (200 departments in total) and one region (AND, BRZ, PER, RDP). Each region has 50 departments. I made a speedometer that shows the % of access on the site by region. I used a combo box + INDEX...

I have some excel data with shows up in this format: <tbody> PT1H11M47S </tbody> I would like to extract the number before the letter "H", in this example result needs to be 1 I can do this by using two formulas: =TRIM(SUBSTITUTE(P16;"PT";"")) removes PT ---> 1H11M47S...

I'm using this formula, which has been working perfectly... that is until it found 2 matches. How can I edit this so it shows the LAST matched value, instead of first??? =INDEX('Q3'!$F$1:'Q3'!$F$332,MATCH(K22,'Q3'!$AB$1:'Q3'!$AB$332,0)) Thanks.

Hi, I've tried looking this up but I haven't found anything close to what I am wanting. I would like a code that when triggered, shows the column letter and what data is in the last row of that column in a message box. The columns are A to L. I hope this makes sense and any help would be...

I've been using excel for years and thought I had seen a lot. I've tried every trick I know and all that Google shows too. I can't delete the rows after my 541 rows in my spreadsheet. The file size says it's only about 541 rows and 22 columns, since it has 175K total size but when you open...

Hello! I recently upgraded my MS Office from 2010 to 2016 and found out that some of my charts are now showing wrong values in their data tables. I googled this problem and found this thread from 2016...

Hello all, I am inquiring about this here because i am seriously stuck. I don't know if the solution is simple or complex in truth i don't exactly know how to search for it. Here is a little background followed by my problem. I work on the service desk of a medium sized company we are a small...

I have a column like the following: 1 20 3 C C50 C 40 I wish to format it so that it shows: 01 20 03 C C50 C 40 How can I do this in a macro? Many thanks fort your help.

When I use camera tool in Excel to copy a chart, I follow instruction carefully but the picture only shows part of the chart. How can I fix it?

So, I have a very simple code: Private Sub Worrkbook_Open() Application.screenupdating=false Application.DisplayWarnings = false Application.Thisworkbook.Worksheets("Sheet1").visible=xlSheetVeryHidden End Sub Private Sub Workbook_Close() Application.screenupdating=True...

Below is a diagram of sheet 1 ( reference sheet) and sheet 2, I would like to have info on sheet 2 to only show if column H from sheet 1 is AA, not sure is a vlookup or if/or formula is best, any help much appreciated Sheet 1 . A B C E...

I have the below formula =IF(AND(OR(H2="#N/A",I2="#N/A", J2="#N/A")),"FAIL","PASS") In the results it either brings "PASS" when passed or shows "#N/A" when failed. How can i get this to say PASS when it's passed and FAIL when it's Failed?

Good morning to all! I have a weekly report from our erp system that shows aging analysis of our sales that contains 16 sheets with rows that aren't the same ever time. I would like the final row of every sheet to be copy in another sheet in order to create a table that shows the results of all...

Hi All I am sure this has already been covered but i cannot seem to find it anywhere by searching, so apologies if this is a repeated request. In column "B" i have a list of dates which are formatted to display as "25/07/2018". In column "C" i have the formula "=TEXT(B2,"dddd"). This displays...

Hi - Is there a way to put the date & time in a cell that shows the last time a macro was run? Thanks!

Hello, I am trying to make my invoice process easier and from my customer base populate the address cells on the invoice using vlookup which i now have sorted; however on the cells in the lookup that are blank, on the invoice it shows a 0 which i would like to show as a blank. i am using the...

I want to know the latest payment date based on the criteria(customer code). I am now using this formula =MAX(IF(Table5[Customer Code]=C5,Table5[Payment Date])) and also CSE. Customer code Latest Payment C5 I5 C6 I6 only the first...

My data has dates with wrong format. It shows up in Excel as "19-Jan" which mean Jan 2019. But if I have the cursor on the cell, actual date shows "1/19/2018" How do I reformat this so that the date reads "Jan 2019" Thank you in advance.

Hello dear users, i use this formula =IFERROR(SMALL($C$2:$C$991,B2),"") to get numbers from c2:c1000 there are 3 results but formula shows only 2 results and if there 10 results it shows 9. can anybody help me please? C contains this formula : =IF(ISNUMBER(SEARCH(Sheet1!$K$2,A2)),B2,"") Regards