shows

Hello, I have the following COUNTIF that works well, but recently realized it's not useful given there are duplicates, thus throwing off my numbers. =COUNTIF($A$1:$X$145, "*"&A213&"*") I have a table of text spanning from A1 through X145 of server names. Given the server, the exact name could...

Hi all, I copied many the heading from many spreadsheets on of the column headings was the date; it was like 08/06/18, two digits year. After copying over 60 headings and created a pivot table, it shows year as 1918 and 1919 instead of 2018 and 2019. Hmm, What went wrong and how do I correct it...

I'm having a really strange issue in Power BI Desktop (64-bit, March 2019 release) that is totally baffling me... I have a dimension table to find cost centers, with the following columns: [Fund], [Cost Center], [Cost Center Name] which have been retained in Power Query from an Excel spreadsheet...

Hi everyone !! I have been working on a macro to evaluate the contents of multiple cells in a spreadsheet and fill in the missing letters of the alphabet with "0". In short, I need to complete the contents of the cell to show 7 characters which will be either seven "0", the letters A to G, or a...

Hi guys, just facing problems with an importet file. Can someone tell me how I need to custom format so it shows the correct time in excel <colgroup><col width="176"></colgroup><tbody> 2017-12-30-09.28.28.937036 so it shows the date and time correctly? Many thanks for your help! Albert...

Hello I use this formula TEXT(A1,"00%") to display some numbers like 0.09398345 into 9%. However, it shows 09% instead of 9%. How can I fix this please? Thanks!

so, i import a csv file into excel....the blank cells aren't actually empty when i do len(a1) it shows "2." if i do "code(a1)" it shows 32. how do i make these cells truly blank?

Hello All, for few of the lines, by if conditions getting the desired value, for few rows it shows as Zero, but it should have been yes or no.

I have a column with text symbols in range of cells. I need to count some, omit others from the count. the range of text is like this: D, DN, ATB, QAQC, DTSS, D3D/N, ETC. Also is there a way to count a particular item, say D3D/N, which shows up as a count of one right now, but in reality...

Is there a code for filtering a table? If the code filtered a table and shows no result the code will do nothing, but if the filtered table has a result it will select the result, is that possible? Thanks

Hi All, I have lotto numbers totaled in A9-Lotto, A10-Bonus Ball, and A11-Power Ball. If cell A9 has 3, A10 has 1, A11 has 1 a total of 5. This would give me a prize of Power Ball 6 if counted as each cell, Because the total is 5 it could also be Power Ball 5 as that would be 4 Lotto and 1 Power...

Hi, On a mileage worksheet in cell C32 i have a value of £23.40 This cell has the formula of =DOLLAR(D31*0.45) so all is ok. I then run a macro which copies this cell data to another sheet. Upon that sheet the columns are added up but i see an issue. In each cell i see this, Using these as...

Hello, I have the following formula on a sheet being used in cell F7: =IF(D7="","",ROUNDDOWN(((T46*K7)+(U46*K9)+(V46*K11)+(W46*K13)+(X46*K15)+(Y46*K17)+(Z46*K19)+(AA46*K21)+(AB46*K23)+(AC46*K25))/D31,0)) I would like to add the ability in that code to type in a percentage value in cell H7 and...

Greetings, How do I modify the below formula to show Yes or No vs. True or False? The formula currently works, but shows True or False vs. Yes or No. =IF(G2="Test",L2>=PERCENTILE($L$913:$L$1911,0.75)) Thanks!

I have created a pivot table and filtered it to show only the top 5 results. However, I have multiple threads of data that contain the same value and as such, the top 5 pivot table shows more than 5 results. Is there anyway to lock this to 5 only?

Hi and thanks in advance! This Macro is just for this eg, but the macro shows my problem Sub AAAa() Dim aDates(1 To 3) 'The Formatting of the selection is = [$-en-GB]dd/mmm/aaaa;@ aDates(1) = Selection.Cells(1) '= "01/11/2018" = 01/Nov/2018 aDates(2) = Selection.Cells(2) '=...

Hi, I have a workbook with 3 worksheets - 1st worksheet shows a yearly calendar, 2nd worksheet shows a list of course schedule, i.e. course name, course duration, start and end date, 3rd worksheet shows Public Holiday of that year. Help needed to set a rule using conditional formatting to...

Hello, I need to count the number of times the letter C appears in a range of cells but i need to excelude the duplicate values out of that count. Let me explain this better: <tbody> day1 day2 day3 day4 day5 day6 day7 day8 08:00 16:00 a a b 16:00 24:00 b </tbody> in this...

2.1Carry out a cross-cast check(on the funding worksheet – Total Funding) that uses secondary columns to perform the same calculation but in a different way to ensure your spreadsheet shows it is accurate. How can I perform a cross check in my total funding that uses secondary columns to...

Hi everyone, I have a userform that pops up when you click on column C any row, but it shows up in the middle of the page can i tell it to show next to the cell ? Thanks Tony