Need Help Please!

S

Santosh080

Board Regular
Joined
Jul 15, 2016
Messages
77
Office Version
  1. 2021
Platform
  1. Windows
Hi Friends

I need some help in excel. Yesterday i face some problem in excel. I have file like below,


1.jpg


Here i want a formula in A2 cell so that when drag that formula i will get result like below,

2.jpg


I have no knowledge in VBA so please anybody help me. I need this in my office.

Thanks
 
Sort by date Sort by votes
You can use that in another column, but you said you wanted it in col A.
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

L
  • Solved
Querying access db from excel - 32 bit to 64 bit conversion
Replies
2
Views
326
JEC
JEC
R
  • Solved
Excel VBA Plus Symbol Automatically Getting Added
Replies
3
Views
188
Fluff
Fluff
B
  • Solved
If field is blank divide by a different cell
Replies
8
Views
200
BigD1980
B
S
  • Question
scraping data from website
Replies
5
Views
345
SHARPY1
S
I
  • Question
Processing data (Transpone?)
Replies
4
Views
118
InfinityMrsn
I

Forum statistics

Threads
1,217,449
Messages
6,136,702
Members
450,025
Latest member
Beginner52

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