after applying formula u can copy as paste values and then select blank and
delete them
On Wed, Nov 11, 2015 at 10:42 AM, Andre Polivarov
wrote:
> Hi Ashish
>
> Thank you for you prompt response.
>
> One thing: I need to have an empty field in a "Parent Category" column if
> a "Category Name" =
Hi Ashish
Thank you for you prompt response.
One thing: I need to have an empty field in a "Parent Category" column if a
"Category Name" = "parent category y"
Group ID Client ID Category ID Category Name Parent Category ID 0 3001
101 parent category 1 (should be empty)
0 3001 102 sub c
see if it helps
On Wed, Nov 11, 2015 at 3:52 AM, Andre Polivarov
wrote:
> Hello,
>
> I need to come up with a Macro to populate 50 rows in column (E)
> Parent Category ID .
>
> I have a table with the following columns: (A) Group ID, (B) Client ID,
> (C) Category ID, (D) Category Name, (E) P
Hello,
I need to come up with a Macro to populate 50 rows in column (E) Parent
Category ID .
I have a table with the following columns: (A) Group ID, (B) Client ID, (C)
Category ID, (D) Category Name, (E) Parent Category ID
I need to populate "Parent Category ID" column for the rows where
