Need multiple selection in input data to produce output data

S

sarwatra

New Member
Joined
Mar 22, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello,
Need Excel formula for data selection and distribute with some complications.
At input column variableName and variableValue has to be printed next to each other.

Wherever recordExtension and recordSubextension is present, the immediately following recordProperty shall be printed next to them(B4,C4).
If recordproperty and its value is there without preceding recordExtension or recordSubextension, it shall be printed as it is(B8,C8).

Column A is input and B and C are output in attached sampleSheet.
 

Attachments

  • Untitled.png
    Untitled.png
    44.8 KB · Views: 5

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You must log in or register to reply here.

Similar threads

S
  • Question
Output text vba should run10000 rows batch wise on every run till it ends.
Replies
0
Views
189
Sathish G
S
S
  • Question
is there a formula that can return multiple matches to criteria and put each match in its own cell
Replies
2
Views
564
supermom28115
S
M
  • Solved
VBA Help - Duplicate & Unwanted Data Removal
Replies
6
Views
295
MoonDancer
M
M
  • Question
Formula to populate the next available cell in a column using data populated in another cell.
Replies
4
Views
483
Marshkevuk
M
B
  • Solved
VBA to save one file as multiple files in location
Replies
7
Views
758
bh24524
B

Forum statistics

Threads
1,216,776
Messages
6,132,659
Members
449,744
Latest member
kauamarcosms

Share this page

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
Back
Top