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: 3

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
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
134
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
543
supermom28115
S
M
  • Question
Formula to populate the next available cell in a column using data populated in another cell.
Replies
4
Views
349
Marshkevuk
M
B
  • Solved
VBA to save one file as multiple files in location
Replies
7
Views
643
bh24524
B
L
  • Solved
Need to find data within a specified range when there are multiple ranges with similar data
Replies
4
Views
298
KRice
K

Forum statistics

Threads
1,215,162
Messages
6,123,382
Members
449,097
Latest member
Jabe

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