Hi,
I'm sure what I'm trying to achieve is easy but my brains not in gear today....
I have a spread sheet which contains 2 rows (E and I) that each have a date stamp in them, what I want to do is calculate if the two dates are on the same day and if so return a value.
I firstly tried...
So I have a command button that when clicked, I would like to sort a cell range in a worksheet.
For some reason, my cells are not sorting using my code below. Any suggestions?
Sheets("Formula Data").Range("I2").Value = rowNum1
Sheets("Formula Data").Range("I3").Value = rowNum2
Sheets("Formula...
Hello,
I'm wanting help with an IF statement.
I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000
=IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000)))
This is...
I am having an issue with my save copy on close VBA code. I am wanting to save a OneDrive shared file (which is a .xlsb file type) upon closing the file to a network drive, but am wanting to save it as a .xlsx file, not .xlsb file type. If I use this code, the file will save, but I get an...
Hi,
I am wanting to combine 2 cells, so C5 (28/02/19) and D5 (1) together but when i do it i get the following.
435241
I am doing the formula of =C5&D5 to get this what else should i be doing?
I am wanting the outcome of 28/02/191 or even 2802191 would be fine.
thanks
I'm trying to compare two columns, say "A" and "B", and if there is a match i'd like to produce the value "retired" in column C. I am really just wanting to work off column A and see if any values in column B match up with column A. Most the values are in a similar style to "abc123456" or can...
Good morning,
I am building a tech tree/flow chart and I had an idea to make it a little more user friendly as it may become quite convoluted down the road. The idea would be to highlight/color change any connected lines/arrows when selecting a specific point(shape) in the chart.
I tried a...
Hi,
I have a survey which outputs a csv file. In one of the fields it returns
August 3, 2018 10:58 AM - Text field
I am wanting to convert it in a table to date format, I have tried =date(cell) but it does not seem to work... any ideas?
Thanks
Hi Everyone
I need a script to replace the '08-05 TO 08-11' with an input box. I need the user to define which pay period they are wanting to lookup and then place that formula into cell D2.
=IFERROR(VLOOKUP(C2,'08-05 TO 08-11'!$C:$Q,2,0),"")
Thanks
Hey, I'm new to VBA and I'm wanting to transfer data from a number of workbooks (Sub Workbook 1, Sub Workbook 2, Sub Workbook 3 etc) to a main workbook (Database).
The location of the data contained within all the Sub Workbooks is the same (Sheet1 & A4:A52).
I'm wanting to paste this data into...
Is there a way to protect a sheet from being viewed until a password is entered unless someone has another idea?
The reason I ask is because I am wanting to have tabs for specific vendors and I do not want vendors seeing each others information.
Thank you,
Hi,
I have the following code
=IFERROR(IF(INDEX('Combined Page'!I:I,(MATCH('Load & Unload (7)'!A272,'Combined Page'!A:A,0)))>=35,"Completed","Available"),"")
Instead of having A272 I wanting to use A then row()
How would I write this?
Thanks
I am wanting to have many ISBNs in column 1. In column 2, I want to be able to type the last 4 numbers of an isbn from the column one list and then have the whole ISBN show up in column 3.
The cell is formatted as GENERAL just like all the other cells in this column.
Most of these cells are filled with data like KS123456GB but i am now wanting to type this 5614930256506582
The problem i face is as soon as i leave the cell its format is changed to scientific 5.61E+15
Why ???
Hi all, hoping someone can help me out
I am trying to change the formatting of a range of cells (G:BM) to two decimal places if the value in cell D1 changes to "SpecificText"
Another small wrinkle in the code, I'm wanting this to run every time the value in D1 is updated.
This seems like it...
Hi guys,
So i have a big table which has males and females on (indicated in column C) and their 100m run times (column H). In column 'I' I am wanting another score based on a vlookup table elsewhere. I am wanting a formula (that works) something along the line of...
IF C2 = M then Vlookup...
Hello all!
I am trying to use and If statement with a table. If eligibility is before today and if complete says no I am wanting to highlight. My problem is when there is nothing to highlight it is highlighting the whole table. It is not proceeding on to the else statement. On another table I...
Hello,
I have a column in spreadsheet 1 of about 700 values (part numbers). I am wanting to search several columns in spreadsheet 2 that might have the part number from spreadsheet 1 within the range of cells that could be an exact match or within a cell that contains the match (ie it could...
Hi,
I am wanting a formula for this spreadsheet.
Column A has a list of descriptions for example "red pens pack of 100" or "red pens pk25"
What i am wanting is in column B to pick up Pack of 100 or pk25 (numbers would change).
Ive got partly there with this...
I have a sheet that lists geological formations with their vertical depth(in column C), in multiple locations. The locations are separated into groups and are identified that way in column A(Group 1, Group 2, Group 3, etc). Towards the middle of each group has the target geological formation...
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.