Hi.
I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words?
Example.
TEST1
TEST2
TEST3
etc down to TEST10.
I go into another cell...
Hi,
Required a formula help for do a different types of workouts as based on data (Work items list-1 & 2) contains in Column A to C, for there required details as follows.
In a Column E, Cell number E4 to be return a Combined work items lists (merged list) of both lists into one list, Sort A...
Hello everybody,
I have the following list of information:
Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :)
Thank you very much everybody.
Best regards,
David
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tasksheet As Worksheet
Dim i As Integer
Dim T2 As Integer
Dim Lr As Integer
ActiveSheet.Unprotect Password:="123"
Target.Locked = False
Set tasksheet = ThisWorkbook.Sheets("Sheet1")
Lr = tasksheet.Cells(Rows.Count, 1).End(xlUp).Row
For...
Good day!
I've dragged Date to the Filter field. When I open the list, I find the entire list not grouped into years>months>days. Is there something I can do to make it happen?
I receive a spreadsheet with the information listed below. The spreadsheet has a list of employees, spouse, children with DOB's and packages (Medical & Dental). I want to create a formula that extracts every employee with the relationship 1 without duplicates. My current formula extracts...
After a solution to a problem I'm having with generating a list that is populated with entries that are defined from a separate table.
So I need to generate a list that looks like this
<tbody>
North
East
South
South
South
South
South
West
West
From a table that is...
Hi
I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column.
I need it all in a different format which I need to grab with single validated list.
Any possibilities??
Sheet...
Hi ,
I need your help, i have a sheet that has several entries (columns and row, sample below) i would like to retrieve the header label based on a certain cell value (i.e. pending) and place the labels in the last cell (who is pending).
in other words, if there is a date in the cell then its...
Hi,
I have the following list of data:-
<tbody>
A
B
7
750<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Verdana}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Verdana}table.t1 {border-collapse: collapse}td.td1 {border-style: solid...
Hi Guys,
Is there a way we can filter list based on the number of character in a cell from lowest to highest using code alone?
Sample Below
Sa1
Sample 23
Samepl
Samples
Output
Sa1
Samepl
Samples
Sample 23
Thanks,
I have a list, in Column A, of 900 customer codes. Examples are AFP, AU3, NKD, YM2, JWW etc... They could be anything, but are always either 2 or 3 characters.
In Column B and Column C I have those codes broken down into the "First two characters"(column B) and then the "Last two...
I need the zip codes associated with a list of nine metro areas that I have. Examples of strings in my list are "Philadelphia", "Baltimore" etc.
I also have a table with two columns - zip codes and associated metro area of each Zip code for the entire USA.
What I'd like to do is have a table...
Hi Guys ,
I have code that will look for any value in a Textbox and displays them in a listbox which works fine but I am having problems trying to find DATES using a the Datepicker "Drop down calender" when I Select a date and press the Find button I set up? I get no result what so ever, not...
Hi Guys,
I have a form with 4 TextBoxe's "TexBox1,2,3 etc" and a ListBox1 were the whole idea is that you enter a value in TexBox1 and the VBA code looks for any and all items on your data "respective worksheet" and lists any/all data that it finds "corresponding to the value in TextBox 1" in...
This is my second post and the first in this particular Forum, so Hello everyone. :)
You'll have to forgive me coz my english is not that great.
Right, let's get down to business.
I have a file that automatically shows at startup, a Dialog Box (UserForm) with a "Date" field, which filling is...
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.