show

Hello, I'm using excel 2016. Every time I try to do a bar chart, it comes up as thin lines going up and down. Modifying doesn't seem to help. Where are the bars? How can I get the lines to go away and show me the thick bars that I want? Thanks in advance.

Hi, Please can someone help me? I would like my commandbutton1 caption to show what is selected in my listbox1. Any help would be appreciated. Thanks Dan

Hi, I have the following code in N2 =(E2*0.1)-35 And it is showing a negative number which is correct. The issue is, I want it to show 0 if the number is negative, how can I achieve this please? Thanks again.

Im not if fixing one of these formulas will fix the others but In cell J3 i have formula =I3+1825, I3 is a date. In K3 i have =J3-TODAY() and L3 I have =IF(K3<0,"EXPIRED",IF(K3<30,"EXPIRING SOON","IN DATE")). When I copy these down and I have blank rows I need them to just be empty.

Not sure if this could be formula or vba. Is it possible to show in cell A20 if the workbook is a xls or xlsm?

Good afternoon all, I am looking to to list data validation over different columns but have it so that the selection in the first column will only show a certain selection in the second. So column A will show a certain supplier then column B will only show what that supplier provides, Column C...

Hi, I have been given a task to create an organisation chart for over 2,000 employees in Excel because it can then be presented in a specific format (effectively I am using grouping to expand and collapse rows to show how the hierarchy flows). This is extremely time consuming and inefficient...

Hi I was watching a video on how to calculate # of mondays between 2 dates. He used this formula = networkdays.int(start date, end date, "0111111") I understand 0111111 to show only Mondays, 1011111 to show only Tuesdays etc but my questions, why he used that as 3rd argument when the 3rd...

Hi everyone, first time posting, but I can't seem to find the solution. When I encode 11/3/19 in a cell, when formatted it would show March 11, 2019. I would like it show as November 3, 2019 instead. Is there away to change this. Thank you very much.

Hey team, I have a worksheet that has rows numbered (in col A) from 1 - 77,757. In col B I want to number each group of rows in deciles. So Rows 1 - 7,776 should show me "1" in col B. Rows 7,777-15,52 should show me "2" in column B and so on. Is there a quick formula that can help me...

I have a doc with 90000 rows. I need to visualise a status. I.e row 10 has on, then row 20 has off, so 11 to 20 have the ON flag and is visible. trying to do this manually and it is taking for ever to identify the start point, double click so it fills down The statuses are in Y, and i want AA...

Hi everyone I have a question in regards to hiding worksheets.. i do know how to do this in the usual manner. although i was wondering is there a way using vba to hide a worksheet, and then show the worksheet if a user clicks on a button, then once the user goes back to the main dashboard the...

This formula is supposed to test if one cell value is less than another, if so, show nothing, if not, then do a percentage calculation and show that, what am i missing? =IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100"))) Happy to share the spreadsheet if it helps, it's nothing personal. Here's how it...

I am looking for a way to count the number of blank cells between a specific column value - in this case the number 1, which represents a member order that was shipped on that specific date. So in my example below, the first member would show one day between orders shipped, the second and third...

As the title states, I haven't dealt with the worksheetfunction alot and I've never dealt with it when it came to a function that I created. So I am not sure why my function doesn't show up but it shows up on the spreadsheet. Any help would be greatly appreciated. Thank You

I'm trying to format cells in hours:minutes. I am putting in 112 to show 112 hours and 0 minutes. I change the format to custom "hh:mm" but when I do that then it shows up as 0:00 and shows; 4/21/1900 12:00:00 AM up above how do I have it show just 112:00?

I'm sure this is really easy but I can't figure it out - I'm trying to find the last cell in column A that has a specific value. I currently have this, which gives me the value that I want, (in column B), but I need to now do it with criteria; Range("J3").Value =...

hello i have data in sheet1 begins range from a2:c10 and userform contains 3 textbox the column c contain values when i fill data in textbox3 and press enter i would show the message " avalible is 200 or 300 or500.etc if the entered number in textbo3 more than what in column c my...

I am wanting to show the top 10 suppliers by spend and show their respective percentages of total sales. Pivot table easily gives me Top 10 but the options for % don't give the opportunity to compare each of the suppliers spend amounts to total sales, as opposed to % of top 10 spend. any...

Hello; This is a new one for me and I've searched a few hours for a solution and either my question isn't quite worded right, it's not be done (can't believe that), Or I'm having Excel "block" because its so straight forward ...I'm at a loss and could use some help/guidance. I have the...