Can I use Concatenate to Apply a value to a certain set of cells in a column?

W

Willygubbins

New Member
Joined
Mar 3, 2017
Messages
3
Hi, I am looking to apply set of values to a set of cels in a column based on criteria being met on row, it is for filtering purposes, so i can then use a normal =IF(AND for a secondary filter to mark one row. I know it can be achieved in pivot tables, but i require the single row formula to pick out rows for suture use. the link below is an example of what i mean. Thanks

https://www.screencast.com/t/r1AhVPoZG
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
You must log in or register to reply here.

Similar threads

T
  • Question Question
Multiple filter criteria using VBA
Replies
2
Views
824
Thundercats
T
R
  • Question Question
How can I get the value of a specific column in a range.
Replies
4
Views
464
Scott Huish
Scott Huish
M
  • Question Question
Macro formula to display values in 2 columns based on other columns
Replies
3
Views
291
myall_blues
myall_blues
J
  • Solved
Code to copy over row if certain criteria is met
2
Replies
18
Views
1K
mumps
mumps
O
  • Solved
I want it all! Using single lookup command to return both multiple Rows and Columns
Replies
4
Views
473
Fluff
Fluff

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

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