Im trying to fing efficient and correct logic to select available data on the worksheet(range), which is based on another set of data.
Since Im unable to explain the logic required, im attaching the file which features 2 worksheets with 2 colors.
1st worksheet is base and 2nd worksheet is the...
Would you know what would be the correct formula for converting year/month to correct date. Example: All rows display 2019/01, 2019/02, 2019/03... etc.
What I really need is to have the date listed as, "01/2019".
I tried to use "Text to Columns" and Format cells, DATE. I remain with date...
I have a column of numbers that sums erroneously to 0. If I add each cell A1+A2+A3, etc it returns the correct value but the sum function always returns 0. I've ensured that all the field formats are numerical. Any ideas what's causing this problem?
hello, i have an issue with some of my colleagues when typing for example shop names, not all of them write it the same way so i need a way to look for the written name in the excel report and look it up from the correct table.
Example:
Wrong Spelling/Name
<tbody>
Carrfour Maadi
Correct...
An extension to this problem:
https://www.mrexcel.com/forum/excel-questions/1107696-approximate-match-vlookup.html
I want to amend this formula:
=IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0)),"Y","N")
to this...
I have some code that copies data to other sheets depending on various options that are selected. This is part of my code that is working:
Select Case tblrow.Range.Cells(1, 6).Value
Case "Yir"
DocYearName = tblrow.Range.Cells(1...
I am pulling down some data and then delimiting it into different columns. Everything looks fine and I then save the document, however, when I re-open the excel document the data appears scrambled....data is not in the correct column and I am not sure why this is happening. Has anyone else...
Hi All
I would like to ask for help with the below query:
In my Excel sheet I have some calculations using cubesets and cubevalues etc
Cubeset1
=CUBESET("my Connection","{ FILTER( { FILTER( { DESCENDANTS( [Location].[Location].[All Locations], [Location].[Location].[Store] ) }, ( [Time].[Time...
Hi all.
I have a userform that allows me to type in a username and a password.
This then is checked to a hidden sheet and if found it opens if not it returns an error as per bellow code;
Private Sub cmBtnLogin_Click()
Dim iFoundPass As Integer
On Error Resume Next
With...
Hello you all, good people.
It has been a few years last time I have been around.
I have been dwelling with the code bellow and the setfocus function is driving me nuts, as it's not working.
Instead, the cursor is moving to the next field in the form.
What am I doing wrong please...
I need to return some access records where a field doesn't contain two specific text strings.
I am using the following to build the querystrQuery = "SELECT InvDate, Agent, BoxRef, Supplier, Invoice FROM SageData WHERE (Supplier Not Like '*CNG*' AND Supplier Not Like '*Swalec*') AND InvDate = #"...
I need help with a formula please to calculate the number of working days between two dates, I'm not sure how to use the WORKDAY function or even if that's the correct way to go.
Good Afternoon,
I have a list of file names in column B that correspond to a list of dates in column A. I am looking for a VBA code to 1) open a file and validate that the correct file has been selected (and just a message box if it is the wrong file) and 2) if the correct file was selected I...
Could I ask for some help from you experts with a formula please. I am having an issue with trying to get the correct result for an investment portfolio that I am building. My isue is obtaining the correct RIO value in cell O27 for the month of July. Here are the cells that are being...
Hi,
This morning i came to use the drop down list but nothing happened.
If i select the cell then data validation i see the following,
SETTINGS
Allow LIST which is correct
Source =HONDANUMBERS which is correct
I click on OK but see an error message The source currently evaluates to an error...
Hello,
I’m stuck trying to figure out what to use to get the correct results
In short, I want to add the results for each employee’s numbers in Column B that belong to the correct Managers name in Column E. Then, show the averages starting in cell E14 (Managers Total)
In my example, the...
Currently I have worksheet 1 and worksheet 2, pivottable, rawdata. Worksheets 1 and 2 both want to pull info from the pivot table, specifically a value associated with a date, when slicer filters are applied the correct data is retrieved but when unfiltered or the incorrect filter applies the...
Please see the attached file and imagine.
http://s000.tinyupload.com/index.php?file_id=58887522662593874105
https://ibb.co/z438Hzn
As you can see I have data from A1 to N20.
I also have data from P column to T column.
What kind of formula can I use so that cells in Q, R S and T show the...
Hi,
Can you please help correct structure of the VBA code on my Excel sheet?
I presently have (with MR EXCEL's help in the past) :
Cells(c.Row, "J").Formula = "=IF(LEFT(RC[-1],1)<> RC[-2],""ALERT"","""")"
I'm trying to modify it by adding an AND function to catch if the most left character in...
I am hoping someone can help me, I have been trying to create a formula that would let our department track turnaround times. When I try Networkdays I get 1 on a same day turnaround. I fixed that by adding -1 to the formula. Now, I am trying to create either a If or Countif function - I...
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.