I would like to extract the postal code from the hundreds of addresses we have on file. The postal code appears in the address in different postition (see sample below).
The postal code format starts with alphabet number alphabet number alphabet number (ie H9Y 2Z3) but sometimes written with...
looking/searching for a right formula that will display a cell on a list based on a given table.
A match result will be based on the following criteria:
1) date
2) timing
3) name
if it match then it display the time start and time end on a separate list/table. I have attached the sample file...
I need to find two cells that contains text from three columns... Based on the attached sample, I would like to know the formula on how to find and compare data please. Thank you for your help.
Appreciate if somebody could help me find a proper "If" or whatever appropriate function/formula with several conditions following the requirement as commented (desc column) in the attached file. Please refer to the attached the file for better understanding please. Thank you for your help.
Greetings! I have thousands of items that includes the 'text' and 'date' in one field. I am using pivot table to generate the chart, however it is my desire to have the sequence sorted by the Date as appears in the ItemDate column.
Attached is the sample file with few data.
It is my intention...
Good Day! I am receiving two files from different department and usually copy/paste them on separate worksheets within my master file.
-----WorkSheet1------
FRUIT STARTsupplyDate STARTprodDate STARTfinalDate
BANANA 1/1/2017 2/2/2017 3/3/2017
ORANGE 4/4//2017 5/5/2017 6/6/2017
APPLE 7/7/2017...
I have three columns (b1,c1,d1) with similar data/text and would like to know a formula that would result as example below. I must combine/put (b1,c1,d1) content into one cell (a1).
A1 B1 C1 D1
Kuwait Kuwait n/a Kuwait
France n/a France n/a
Saudi Arabia n/a n/a Saudi Arabia
Thank you in...
Greetings!
I have a thousands of item that requires me to identify which item is part or belong to what item/level.
I have attached an excel sample where
a) Column B (level), C (Item Number) and D (DESC) are the given data.
b) Column A is the output/result that I would like to have which...
Please help me to find a solution to my requirements: Basically, I am needing of two functions
1) Function 1 is to make a sequential list based on the ID number. It starts as "Attachment0" onwards (from Attachment0 to Attachment30).
If number column has a similar value then 'attach' columns...
Given the following information below where "date", "name" and "code" is column A, B and C respectively, I would like to know the formula that will count the cells of Column B with text based on the date I entered in (A9) which matches column A dates. The result will then shows in cell (A10)...
I am in need of formula that would copy/extract from one column (A2-A4) and show the result in different cell/column (B2-B4) based on the defined keywords (H1).
SAMPLE DATA:
A2: The boy and girl is walking.
A3: the girl is good. the boy is good and tall. the mother is sleeping.
A4: Leo...
I have more than 10 thousands of scientific references placed under one cell and I would like to separate the authors name on another columns. I have searched the site and tried putting different formula to get the result I wanted but cant get it. Appreciate any assistance please.
Example...