Hello,
I'm trying split the cell into multiple data sets however i have some difficulties to get some of them pulling correctly.
<tbody>
Data sets is looking like below and it's divided from each information by "|" and each data set might have different number of characters...
I have a bunch of "*log.gz" files stored in my "R:" and would like to dump/convert into my "G:/INFO/Quality/Transfer" File so they open up in excel correctly
Request in VBA
I am trying to add the following Column A1: C1 to get total in Column D1 and can't seem to get it to come out correctly. Please help.
Column A1= 1:38 (1hr,38 minutes
Column B1= :28 (28minutes)
Column C1= :17 (17minutes)
Column D1= 2:23 (2hrs, 23 minutes)
Hi,
I would like to sort data in based on a rank criteria:
<tbody>
<tbody>
responds to questions
</tbody>
2
<tbody>
uses pronouns correctly
</tbody>
1
<tbody>
uses advanced propositions
</tbody>
0
</tbody>
2 = usually
1 = sometimes
0 = never
I would like to produce an...
Hi everyone,
I have a weird problem with SUMIF formula.
My formula in cell R1046 is :
=IF(SUMIF(C:C,C1046,L:L)=0,"paid","not paid"
So, the basic is :
If column C contains the value of the regarding row then calculate the value of column L.
As we can see, inside the blue box - Excel...
Hi,
I'm importing date from CSV file including date into excel. The date field in the CSV file is configured as "mm-dd-yy hh:mm:ss".
The date cells in the excel sheet is configured as dd-mmm-yy hh:mm:ss.
My problems is that the date imported will show correctly if the day is below 13 but...
I cannot get the result that I am looking for and I am guessing that I have the parenthesis incorrect.
The formula below works correctly
=IFERROR(VLOOKUP(A721,Available!A:A,1,FALSE),"")
But I want to add another condition that the formula looks at first
=IF(Available!C5<1,"")
So if C5<1 then...
hi all not one for posting normally as i like to work things out for myself, but this error im having has me pulling my hair out.
i found a dashboard online for match results and statistics that i edited to show lineups, goalscorers etc. dependent on the match selected the information will...
I have the following formula in a spreadsheet which works correctly, however we have a new team member and the count does not work for them, i presume it has something to do with " ' " in their surname.
=COUNTIFS('Sharepoint history'!H:H,SUBSTITUTE('Instructions '!L3," ","*"),'Sharepoint...
Hello
I am trying to write a formula that will go through a column of numbers/receipt codes and will count how many times a set first two numbers appear (as the first two numbers determine a location)
any help would be appreceiated as I am struggling to write this forumla correctly
Thanks
Hello,
I am trying to write a few lines of code that will:
- loop through all worksheets in my workbook,
- and if the worksheet name begins with "GL",
- then add and name a small range in that worksheet. And, range name will = worksheet name
I have code that partially works, but looking...
My worksheet displays the date correctly, but when the UserForm pulls the date in, the date is not formatted correctly. I've searched this, and other forums and none of the options that I've found are working. Any suggestions?
'Format(Me.txt_DCStart, "MM/DD/YY") =...
I am using the following formula in a cell and when I input Y into C3 I am getting #Name ? instead of "this is broken"
What am I doing wrong?
=IF(C3=Y,"This is broken", "")
If I change the formula to: =IF(C3=15,"This is broken", "") and put 15 in C3, the cell with the formula reads...
In cell A2 i have "=IF(C2="","",TEXT(C2,"yyyy"))" in cell c2 i have 01/01/2016 so in cell A2 i have the result of 2016.
Which is correct.
I am wanting in T2 a formula to say Yes this was last year (2016) so far i have the formula of "=IF(YEAR(TODAY())-1=A2,"Yes","")" but it isnt working...
Hi. I am looking to be able to when filtering a list on Sheet2 which is created/populated by using index/match which looks to a database contained on Sheet1 to count/sum up TEXT results ignoring hidden rows which correctly are filtered out.
Numbers work but text I am having a problem with -...
Hello, I'm having trouble correctly combining two Excel functions into one string.
My Choose Function is operating correctly. I would like my formula to read: Choose(2010,2011,2012),IF(1=S, make it S, if not make it 0).
Any help is greatly appreciated.
CHOOSE Function...
I have Y and N answers in a multiple category spreadsheet. I am trying to pull them into a Pivot Table but, cannot seem to get it filtered correctly. The counts and Y/N are not filtering correctly.
<tbody>
Filters
Columns
NONE
VALUE
Rows
Values
CORRELATED DATA
ALL COLUMNS...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.