how could copy the value from E to F

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
How could i search if value matches in column B , take a copy of next value in
1655314025780.png
column E and put it into another cell.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,982
Office Version
  1. 365
Platform
  1. Windows
Welcome to the Board!

Your question is a bit unclear.
How about walking us through a particular example based on the data you posted?
 

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
Welcome to the Board!

Your question is a bit unclear.
How about walking us through a particular example based on the data you posted?
firstly i would to thank you for your quick response , here i'm i want to apply condition in column B to match a value if it found matches then take the next opposite value in E and put it in another cell
 

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
as you can see i have many duplication in B so how i could determine the searched value in column B (matches) have the value of the one in column E
 

Attachments

  • Capture.PNG
    Capture.PNG
    18.2 KB · Views: 7

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,982
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

I am afraid that doesn't clarify things for me to all. Your description is too generic.
Remember, while this issue is familiar to you, it is not for us. All that we know is what little have shared with us.
So be as detailed as possible.

So I will request again, please walk us through an actual example, referencing actual values and cell addresses.
Pick any value, and tell us what particular value should go in which particular cell?
Explain it, completely in detail, in English.

Maybe show us your expected output (you mention column F, but do not show it in your images).
 

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
PARTITIONNON JOB
INFOPRO_INFOPROAUBRMS_DUP_J411702/QSECOFR/BRMS_DUP_J
CPF1124Travail 411702/QSECOFR/BRMS_DUP_J démarré le 15/06/22 à 05:00:00 dans le sous-système QCTL de QSYS ; soumis le 15/06/22 à 05:00:00.
CPI671FCartouche IFP046 volume IFP046 montée sur l unité TAPMLB04.
CPF1164Travail 411702/QSECOFR/BRMS_DUP_J arrêté le 15/06/22 à 05:42:53; temps UC 17,271; code fin 0 .
INFOPRO_INFOPROFITRTQUOTDUP423839/DFIBACKUP/TRTQUOTDUP
CPF1124Travail 423839/DFIBACKUP/TRTQUOTDUP démarré le 15/06/22 à 04:00:00 dans le sous-système DFI_1BY1 de DFI_ENV ; soumis le 15/06/22 à 04:00:00.
CPD2639Unité TAPMLB01 déjà en fonction.
CPD2639Unité TAPVRTBRMS déjà en fonction.
CPI671FCartouche IFP010 volume IFP010 montée sur l unité TAPMLB01.
CPF1164Travail 423839/DFIBACKUP/TRTQUOTDUP arrêté le 15/06/22 à 05:17:04; temps UC 25,803; code fin 0 .
INFOPRO_INFOPROAUBRMS_DUP_J411702/QSECOFR/BRMS_DUP_J
CPF1124Travail 411702/QSECOFR/BRMS_DUP_J démarré le 15/06/22 à 05:00:30 dans le sous-système QCTL de QSYS ; soumis le 15/06/22 à 05:00:00.
CPI671FCartouche IFP046 volume IFP046 montée sur l unité TAPMLB04.
CPF1164Travail 411702/QSECOFR/BRMS_DUP_J arrêté le 15/06/22 à 05:42:53; temps UC 17,271; code fin 0 .
INFOPRO_INFOPROFITRTQUOTDUP423839/DFIBACKUP/TRTQUOTDUP
CPF1124Travail 423839/DFIBACKUP/TRTQUOTDUP démarré le 15/06/22 à 04:00:00 dans le sous-système DFI_1BY1 de DFI_ENV ; soumis le 15/06/22 à 04:00:00.
CPD2639Unité TAPMLB01 déjà en fonction.
CPD2639Unité TAPVRTBRMS déjà en fonction.
CPI671FCartouche IFP010 volume IFP010 montée sur l unité TAPMLB01.
CPF1164Travail 423839/DFIBACKUP/TRTQUOTDUP arrêté le 15/06/22 à 05:17:04; temps UC 25,803; code fin 0 .
 

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web

ADVERTISEMENT

here what i want exactly,
1- regular expression to extract the value in red if the value in Green found
2- make a search in B column with one of its values & if value found then copy the result of the regular expression next to the value to another cell
 

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
modification
regular expression if the value in red found , then the value in green extract or copy to another cell one by one
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,982
Office Version
  1. 365
Platform
  1. Windows
You did not mention that you require "regular expression" in your original question.
I do not use them, so I afraid I cannot be of help here (had I known that this was a requirement, I would have not replied).
Hopefully, someone else who knows them can.
 

tomy_xx

New Member
Joined
Jun 15, 2022
Messages
20
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
Ok what about second part
Infopro Report.xlsx
ABCDEFG
1PARTITIONNON JOB
2
3INFOPRO_INFOPROAU BRMS_DUP_J 411702/QSECOFR/BRMS_DUP_J
4 CPF1124Travail 411702/QSECOFR/BRMS_DUP_J démarré le 15/06/22 à 05:00:00 dans le sous-système QCTL de QSYS ; soumis le 15/06/22 à 05:00:00.
5 CPI671FCartouche IFP046 volume IFP046 montée sur l unité TAPMLB04.
6 CPF1164Travail 411702/QSECOFR/BRMS_DUP_J arrêté le 15/06/22 à 05:42:53; temps UC 17,271; code fin 0 .
7INFOPRO_INFOPROFI TRTQUOTDUP 423839/DFIBACKUP/TRTQUOTDUP
8 CPF1124Travail 423839/DFIBACKUP/TRTQUOTDUP démarré le 15/06/22 à 04:00:00 dans le sous-système DFI_1BY1 de DFI_ENV ; soumis le 15/06/22 à 04:00:00.
9 CPD2639Unité TAPMLB01 déjà en fonction.
10 CPD2639Unité TAPVRTBRMS déjà en fonction.
11 CPI671FCartouche IFP010 volume IFP010 montée sur l unité TAPMLB01.
12 CPF1164Travail 423839/DFIBACKUP/TRTQUOTDUP arrêté le 15/06/22 à 05:17:04; temps UC 25,803; code fin 0 .
13INFOPRO_INFOPROAU BRMS_DUP_J 411702/QSECOFR/BRMS_DUP_J
14 CPF1124Travail 411702/QSECOFR/BRMS_DUP_J démarré le 15/06/22 à 05:00:00 dans le sous-système QCTL de QSYS ; soumis le 15/06/22 à 05:00:00.
15 CPI671FCartouche IFP046 volume IFP046 montée sur l unité TAPMLB04.
16 CPF1164Travail 411702/QSECOFR/BRMS_DUP_J arrêté le 15/06/22 à 05:42:53; temps UC 17,271; code fin 0 .
17INFOPRO_INFOPROFI TRTQUOTDUP 423839/DFIBACKUP/TRTQUOTDUP
18 CPF1124Travail 423839/DFIBACKUP/TRTQUOTDUP démarré le 15/06/22 à 04:00:00 dans le sous-système DFI_1BY1 de DFI_ENV ; soumis le 15/06/22 à 04:00:00.
19 CPD2639Unité TAPMLB01 déjà en fonction.
20 CPD2639Unité TAPVRTBRMS déjà en fonction.
21 CPI671FCartouche IFP010 volume IFP010 montée sur l unité TAPMLB01.
22 CPF1164Travail 423839/DFIBACKUP/TRTQUOTDUP arrêté le 15/06/22 à 05:17:04; temps UC 25,803; code fin 0 .
Dupli
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,159
Messages
5,857,709
Members
431,891
Latest member
shirazx3

We've detected that you are using an adblocker.

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.
Go back
Top