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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

R
  • Solved
Excel VBA Plus Symbol Automatically Getting Added
Replies
3
Views
126
Fluff
Fluff
B
  • Solved
If field is blank divide by a different cell
Replies
8
Views
149
BigD1980
B
S
  • Question
scraping data from website
Replies
5
Views
296
SHARPY1
S
E
  • Question
Split Workbook VBA w/Default Value for Sensitivity Labels
Replies
1
Views
464
Jeffrey Mahoney
Jeffrey Mahoney
L
  • Question
Lost in Strings-When running macro another Excel workbook is opened
Replies
1
Views
110
Lacampeona
L

Forum statistics

Threads
1,216,082
Messages
6,128,713
Members
449,464
Latest member
againofsoul

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