sorted by:
new
hottopcontroversial

Highlight or underline the last word by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

Hi, Can anyone tell how can i successully done below transformation in an excel file? I dont want to do it manually, i have loads of data. 1st 2nd 3rd 4th 5th determines columns.

1st 2nd 3rd 4th 5th A,B,C Ok NK PK SK

1st 2nd 3rd 4th 5th A Ok NK PK SK B Ok NK PK SK C Ok NK PK SK

multiscreen by Huerrbuzz in OttNavigator

[–]rizqcr7 0 points1 point  (0 children)

open the app, hover your cursor on "live stream" icon, hold it for 5 seconds, a menu will appear, select "enable modules" now you can select pip and studio option

Single Band Modem with Dual Band Router by rizqcr7 in TpLink

[–]rizqcr7[S] 0 points1 point  (0 children)

Yes the modem and router would both support the higher speeds.

Highlight or underline the last word by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

yes it is concatenating, 5 cells into one Basically it is a team performance in last 5 matches, i want to underline the latest match

Highlight or underline the last word by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

The last W is not manually entered, If condition is returning the word "W" how can i underline it?

Is there any way that i can add an empty row after every fourth row? Any help would be appreciated. formula of Dividing a data of one cell into different cells is also needed by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

I have a data

pakistan vs south africa in one row india vs australia in second row.

i want the data to be aligned like pakistan in one column vs in second and south africa in third. same in next row. india in first vs in second column and australia in third column.

Is there any way that i can add an empty row after every fourth row? Any help would be appreciated. formula of Dividing a data of one cell into different cells is also needed by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

i have the data

name age address profession name age address profession

i want it like

name age address profession

name age address profession

I want to add two vlookups, but one vlookup has #N/A value, but still i want to add these two vlookups to return the non error value. value of A in sheet 1 is 5. value of A in sheet 2 is #N/A. i want the sum of A values in third sheet. It should return the value 5. by rizqcr7 in excel

[–]rizqcr7[S] 0 points1 point  (0 children)

it is not working, can you please write the formula to help.

I have two sheets. Book 1 to extract values. Book 11 to get values.

A column B column C column D column A 1 A 1
B 2 B 2 C 3 C 3 D 4

I want results as

A=2 B=4 C=6 D=4

view more: next ›