showing

Hi, I was trying to sort out and make a consolidated table from a big data file of size around 18 MB. In this data file, I have to take out the dates from one sheet and paste on other sheet. So, I created one array named Dates() and dimmed it as Date. (For your information, I have to do this in...

HI Guys i have he below data <tbody> Jan Feb Mar 2017 10 11 5 2017 target 5 9 13 2018 14 13 12 2018 Target 10 15 11 2019 7 3 29 2019 target 10 2 8 </tbody> I am trying to create a graph with months on the X axis and then 3 bars showing , which represents each year and inside...

I have a workbook with cells linked via copy and paste link. Thing is when cells are blank the corresponding cells that linked to they are showing as "0". Is there anyway I can stop this happening.

What is the best way to insert images into New Threads? I cannot seem to get this feature to work. I am using Snagit to copy screenshots which will assist me in posting my thread and showing exactly my issue, Thank you.

Hi, i'd like to asked, is this the limit of how many line textbox could show text with a formula linked to a cell? on the left is my merged cell showing all the lines, while on the right is my textbox not showing just like my merged cells. can anyone explain? or is there any turn around hint?

Hi, I'm using the following Month = FORMAT(MONTH(Sheet1[Date]),"MMMM") To get the month name, however, all Jan dates are showing as December, the rest are showing January. Any ideas what could be wrong? Sheet1[Date] is a date data type. *All good, worked it out.

i am trying to extract alphanumeric data like EXAMPLE: 785abc25d so i tried so please help me i am using excel 2010 version =INDEX(ROW(INDIRECT("1:"&LEN(A36))),N(IF(1,MID(A36,ROW(INDIRECT("1:"&LEN(A36))),1)+0))) after i pressed f9 key to evaluate so it is showing...

I have 6 pieces of data in a column 109 109a 109b 110 110a 110b how do i sort this column of data so it looks like what i am showing here? Help much appreciated.

I want to track all the changes in our headcount:* All the dates employees were hired, which position they were hired for, and which team they belonged to* All the dates employees were promoted, including the new positions (and the team)* All the dates employees resigned / left the companyFor...

Hi, I am by no means an expert in MS Excel, but most of the times I can find the solutions myself. Not this time... I want to track all the changes in our headcount:* All the dates employees were hired, which position they were hired for, and which team they belonged to* All the dates...

Hi All, I have two columns of dates. One is support tickets opened one is support tickets closed. Each date entry on a new row represents a ticket. When I try to put a pivot chart together the opened and closed per month figure is coming out the same which it shouldn't be. What I would like...

Hello there, I am using this code in my VBA routine: Application.Workbooks(RTBook).Sheets(ATTargetSht).Range("BL3:BL" & LastRowPVTable).Formula = "=TEXT(MID(BN3,2,2),""00"")" Application.Workbooks(RTBook).Sheets(ATTargetSht).Range("BL3:BL" & LastRowPVTable).Formula =...

In my data, 2018 includes items A,B,C only (eg values 10, 20, 30) 2017 contains data for item A, B, C, D (eg values 15,25,35,45) In my Matrix report in PowerBI, I am showing 3 columns:- Item, 2018Values, 2017Values 2017Values is a DAX measure created using SAMEPeriodLastYear. Then I have a...

Hello group, Looking for why the following line doesn't work as expected on occasion (probably about 15% of the time) l_rngCurVerse.Characters(l_lngStartPositionOfOldAnnotation, l_lngLengthOfOldAnnotation).Text = l_strCurrentVerseAnnotation I can see all of the variables in this particular...

I have a few simple list boxes, one showing a list of vendors and the other showing a list of months. Every time I save and exit the workbook, the list boxes shrink from the bottom so when I reopen said workbook, some of the options inside the boxes are not visible. How can I get these list...

I have the following formula im having a little trouble with. =(C12&" "&D12&"x "&E12&" "&F12) C12 is formatted as Fractional and D12 is formatted as Short Date. They are showing up as numbers in a decimal. Is there a way to have the format called out for each cell in the formula.

My "Days Worked" column keeps breaking with every new month... and i think i have it coded wrong. My formula is =NETWORKDAYS($C$7,$C$8)*-1-$C$11 C7 is Today / C8 is Start Date (beginning of the month) / C11 is Holidays (which i manually enter due to company picks).. Currently it's showing...

I've just discovered Power BI for desktop (literally two days ago) and am enjoying playing around with it, but I've come across a charting problem - something that I could easily do in Excel that I can't figure out how to do in Power BI. I have a table of sales data showing quarter number (Q1...

I've only just found out in Microsoft Word how to type a fraction in the "normal" way, that is with the digits one above the other - if .5 is wanted as a fraction, type 1 followed by / followed by 2. Then press the space bar. The 1/2 changes to 1 over 2.(can't show it here!) I have been looking...

What would be the most direct way to determine if the date of a cell matches the month and date of another cell? For example, cell A1 = 10/12/18 and I need an if statement to compare its date to a row showing various months and years - b1 = 10/17, c1 = 10/18, d1 = 10/19 Thus, need an If...