Hey guys, I have something I need help with.
I need to convert the following formula into an excel formula. Any help? I'll be honest, I don't fully understand this, it's from a website which converts football actions into meaningful statistics. The post is here...
I have a series of time values which are formatted thus e.g. 28hr 46m 22s
I have some code that builds up a string containing the "minute" vales of these strings, so, for example 10h 15m 17s would display as 615 (10*60+15)
I achieve this with:
MinuteValue = (Hour(Selection) *...
Working on a weird issue here. Look on the interwebs and found nothing for my specific issue. The DateValue syntax doesn't seem to work in the event the data string makes no sense.
So here is how some of the dates come in;
Date as it comes in
Converted to General...
Hello! I have looked up and tried every link and suggestions already on line that I could. Unfortunately, I'm still having trouble converting a CountIf function to SumProduct. I'm doing this because I need to link my CountIf to a closed worksheet.
My original CountIf function...
I have the following formula as an example in cell F1 of my sheet:
This formula is in every single row of column F to the bottom of the sheet - in this case row 205102.
As you can imagine, it slows...
hello i am new to vba can any one help me converting this excel formula =INDEX($C$7:$C$2001,AGGREGATE(15,3,IF($C$7:$C$2001=$J$5,ROW($C$7:$C$2001)-ROW($C$7)+1),ROW(A1)))
to vba code
please do mention where to type value that needs to be searched and where will i get the answer
I'm trying to covert the following Excel IF statement to a custom column in Power BI: =IF(O2<>P2,IF(O2>0,O2,P2),IF(P2=0, N/A,P2)) (replacing the cells with the column names) I cannot for the life of me figure out the syntax.
Any assistance is GREATLY appreciated.
ok so the data i pull in has the date in this general form:
20190502 .....I want to covert that easily into a date format so that I can compare the number of days between the pulled in date and another date
is there an efficient way to do this? ideally via VBA.
I have been beating away at this keybod for hours and i am stuck trying to convert my gps coordinates to another format. Can someone help with this?
here is what I am trying to do:
Cell A Cell B
N 34 37.760,W 84 11.565 ----->...
Hi, i am trying to unprotect my worksheet to run below code for converting columns into text and then protect sheet again but somehow its not working.
Dim ws As Worksheet
Set ws = Worksheets("EWEB")
I have a list of values that I need converted.
They look like this:
and I am trying to get them changed to
Any and all help Appreciated!
I am trying to solve a problem. Assume I have a label that is 100 twips in width (default unit from my research) for a userform. I need to count how many characters of a specific font can fit into that 100 width without going to a new line. That would require converting these units of measure...
I have this date format as text and would like to convert it to just numbers:
This is what I have '3ys 7ms 15ds' and I would like to try and display it as a round number say 3.70 or 3.07 whichever works
I have 2,000 spreadsheets in a folder - I would like some code that;
- opens each spreadsheet one at a time
- in sheet "Summary", copy/paste special whole sheet
- in sheet "Summary", columns C&D - I only want the first letter of any text to remain (converting names to initials)
- delete all...
I'm hoping this is an easy fix. I need a formula that will average data in a column if a column contains x or y.
Currently I have:
However, this is returning 4.49 when it should be 4.83. It might be converting blanks to 0 hence the...
I have selected three cells A1 = Day, B1= Month & C1=Year. Now I want to get date format in cell D1 as DD-MM-YYYY.
For example, A1=22, B1=10, C1=1975 and the result will be in D1= 22-10-1975.
How can I do that?
I ave just completed converting decimal to binary without the use of DEC2BIN. However now I am moving onto converting this concatenated 8 bit binary number into Hex, without the use of BIN2HEX.
What I have done so far is set up a vertical table with two columns, one with 16 values...
Is there any way to keep links to other sheets in a workbook when converting the whole workbook to a pdf?
I have certain external links which all convert fine, but any internal links I have (e.g. a table of contents) loses all the links once saved as a pdf. I've tried Save As and Export as PDF.
I am reading the article below and although he gave an example why converting number to text is needed, I did not understand the example. Can you please give me examples/reasons why that is needed? Thank you